home / sf-trees

sf-trees

Custom SQL query returning 32 rows

Query parameters

This data as .json

rowidTreeIDqLegalStatusqSpeciesqAddressSiteOrderqSiteInfoPlantTypeqCaretakerqCareAssistantPlantDateDBHPlotSizePermitNotesXCoordYCoordLatitudeLongitudeLocation
3787 65935 1 141 1343 Greenwich St 1 1 1 1   06/08/1990 12:00:00 AM 14   Permit Number 28954 6006463.24964 2119706.38252 37.800674552539604 -122.421775955514 (37.8006745525396, -122.421775955514)
28719 65929 1 55 35 Palm Ave 1 1 1 1 1 06/04/1990 12:00:00 AM 8   Permit Number 28948 5995849.4697199995 2114245.46982 37.7850761197315 -122.45810832997 (37.7850761197315, -122.45810832997)
35039 65901 1 55 180 Palm Ave 1 1 1 1 1 06/08/1990 12:00:00 AM 11   Permit Number 28908 5995949.76859 2113077.47191 37.7818748717492 -122.457676787407 (37.7818748717492, -122.457676787407)
37573 65688 1 26 184 Palm Ave 1 1 1 1 1 05/31/1990 12:00:00 AM 8   Permit Number 28909 5995950.945309999 2113042.38118 37.7817785895398 -122.45767017670201 (37.7817785895398, -122.457670176702)
40601 65925 1 26 80 Palm Ave 1 1 1 1 1 06/04/1990 12:00:00 AM 11   Permit Number 28942 5995918.83699 2113960.3676 37.7842972908104 -122.45784770445 (37.7842972908104, -122.45784770445)
47966 65893 1 55 116 Palm Ave 1 1 1 1 1 05/31/1990 12:00:00 AM 9   Permit Number 28900 5995931.63622 2113606.82428 37.7833272906212 -122.457777832601 (37.7833272906212, -122.457777832601)
53212 65927 1 16 47 Palm Ave 1 1 1 1 1 06/04/1990 12:00:00 AM 18   Permit Number 28946 5995857.72267 2114184.09174 37.7849080661642 -122.45807533396002 (37.7849080661642, -122.45807533396)
59630 65900 1 55 168 Palm Ave 1 1 1 1 1 05/31/1990 12:00:00 AM 8   Permit Number 28907 5995947.205130001 2113189.79047 37.782183121353896 -122.457693785315 (37.7821831213539, -122.457693785315)
60857 65931 1 55 115 Palm Ave 1 1 1 1 1 06/04/1990 12:00:00 AM 7   Permit Number 28950 5995872.00692 2113664.41853 37.7834820032566 -122.45798829440201 (37.7834820032566, -122.457988294402)
61823 65584 1 141 251 Peru Ave 1 1 1 1   01/24/1990 12:00:00 AM 1   Permit Number 28484 6004276.22204 2093135.2738 37.7275930871392 -122.427449994148 (37.7275930871392, -122.427449994148)
67659 32542 1 160 91 Palm Ave 1 1 1 1 1 06/04/1990 12:00:00 AM 6   Permit Number 37040 5995849.2868099995 2113912.80222 37.7841626930639 -122.458084878555 (37.7841626930639, -122.458084878555)
101992 66205 1 31 285 Mullen Ave 1 1 1 1   10/03/1990 12:00:00 AM     Permit Number 29289 6010420.85602386 2100006.0506029 37.746804390663 -122.406691826217 (37.746804390663, -122.406691826217)
116426 65602 1 31 114 Maynard St 1 1 1 1 1 02/06/1990 12:00:00 AM 13   Permit Number 28504 6004165.03379 2093741.9135900002 37.729252495484 -122.427877581308 (37.729252495484, -122.427877581308)
123947 53439 1 26 52 Palm Ave 1 1 1 1 1 06/04/1990 12:00:00 AM 4   Permit Number 28945 5995912.02924 2114136.39379 37.784780220516794 -122.45788399909901 (37.7847802205168, -122.457883999099)
126062 65924 1 55 86 Palm Ave 1 1 1 1 1 06/04/1990 12:00:00 AM     Permit Number 28940 5995916.1594989 2113912.59060771 37.784165954142 -122.457853509092 (37.784165954142, -122.457853509092)
129681 65814 1 26 90 Palm Ave 1 1 1 1 1 05/19/1990 12:00:00 AM 12   Permit Number 28802 5995920.72408 2113894.39262 37.784116249570296 -122.45783640007099 (37.7841162495703, -122.457836400071)
129940 65896 1 55 152 Palm Ave 1 1 1 1 1 05/31/1990 12:00:00 AM 6   Permit Number 28903 5995943.06706 2113318.17907 37.7825354045306 -122.457717393964 (37.7825354045306, -122.457717393964)
133443 65895 1 26 126 Palm Ave 1 1 1 1 1 05/31/1990 12:00:00 AM 6   Permit Number 28902 5995934.2793 2113524.40657 37.783101145423394 -122.457762722955 (37.7831011454234, -122.457762722955)
146577 65897 1 26 156 Palm Ave 1 1 1 1 1 05/31/1990 12:00:00 AM 6   Permit Number 28904 5995942.3619800005 2113297.5350200003 37.7824786809659 -122.457718338978 (37.7824786809659, -122.457718338978)
156275 65934 1 55 150 Palm Ave 1 1 1 1 1 05/31/1990 12:00:00 AM 7   Permit Number 28953 5995941.68563 2113369.58328 37.782676467432 -122.45772589379801 (37.782676467432, -122.457725893798)
157185 59260 1 142 1400 Polk St 1 1 1 1   03/13/1990 12:00:00 AM 8   Permit Number 28432 6006768.1927 2115720.7306 37.7897481413543 -122.42043766215099 (37.7897481413543, -122.420437662151)
167683 65928 1 55 41 Palm Ave 1 1 1 1 1 06/04/1990 12:00:00 AM 4   Permit Number 28947 5995850.771380001 2114206.39787 37.7849689134171 -122.45810099794 (37.7849689134171, -122.45810099794)
179367 65899 1 55 166 Palm Ave 1 1 1 1 1 05/31/1990 12:00:00 AM 8   Permit Number 28906 5995945.57364 2113203.14409 37.782219693115394 -122.45770039603998 (37.7822196931154, -122.45770039604)
181402 65926 1 26 74 Palm Ave 1 1 1 1 1 06/04/1990 12:00:00 AM 5   Permit Number 28944 5995917.2932400005 2113985.23252 37.784365474541 -122.457854845171 (37.784365474541, -122.457854845171)
182671 65601 1 142 112 Maynard St 1 1 1 1 1 02/06/1990 12:00:00 AM 12   Permit Number 28503 6004142.9253 2093740.45732 37.7292472461511 -122.42795390857201 (37.7292472461511, -122.427953908572)
182797 65606 1 141 142 Maynard St 1 1 1 1 1 02/06/1990 12:00:00 AM 47   Permit Number 28510 6004334.881680001 2093748.3562099999 37.729279792610505 -122.427290860879 (37.7292797926105, -122.427290860879)
183148 66354 1 142 334 Prague St 1 1 1 1   12/21/1990 12:00:00 AM 13   Permit Number 29475 6003787.88189 2089236.55246 37.7168604267574 -122.428860361341 (37.7168604267574, -122.428860361341)
45437 71814 2 55 68 Palm Ave 1 1 1 1 1 05/19/1990 12:00:00 AM 18     5995915.832219999 2114038.69637 37.7845121880339 -122.45786376992201 (37.7845121880339, -122.457863769922)
73423 72214 2 31 1799 Revere Ave 3 1 1 1 1 08/18/1990 12:00:00 AM 12     6014033.56934 2095149.8862 37.7336718422767 -122.39385944784901 (37.7336718422767, -122.393859447849)
188342 70057 2 31 1799 Revere Ave 4 1 1 1 1 08/18/1990 12:00:00 AM 12     6014037.2583099995 2095146.8497099997 37.7336637097057 -122.393846481427 (37.7336637097057, -122.393846481427)
110657 71815 3 26 151X Palm Ave 5 1 1 4 2 05/19/1990 12:00:00 AM 10 3x3   5995888.68435 2113315.23973 37.782524209628704 -122.45790532062 (37.7825242096287, -122.45790532062)
146068 5446 3 100 500X Dolores St 14 11 1 2   03/20/1990 12:00:00 AM 90 6   6004896.4850004995 2105439.5076575 37.7614127588524 -122.426181340905 (37.7614127588524, -122.426181340905)
Powered by Datasette · Query took 92.974ms