trees
390 rows where qSpecies_id = 126 sorted by rowid descending
This data as json, CSV (advanced)
rowid ▲ | TreeID | qLegalStatus_id | qSpecies_id | qAddress | SiteOrder | qSiteInfo | PlantType | qCaretaker_id | qCareAssistant | PlantDate | DBH | PlotSize | PermitNotes | XCoord | YCoord | Latitude | Longitude | Location | Fire Prevention Districts | Police Districts | Supervisor Districts | Zip Codes | Neighborhoods (old) |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
193936 | 200175 | DPW Maintained 1 | Yucca gloriosa :: Spanish Dagger 126 | 1022 Jamestown Ave | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 16 | Width 0ft | 6013884.9652 | 2089743.6718 | 37.7188192082582 | -122.393994895467 | (37.7188192082582, -122.393994895467) | 10 | 3 | 8 | 58 | 1 | |||
193806 | 199575 | DPW Maintained 1 | Yucca gloriosa :: Spanish Dagger 126 | 1300x De Haro St | 25 | Median : Yard | Tree | DPW 1 | 27 | 6012270.74731 | 2102100.89416 | 37.7526597061983 | -122.400442161487 | (37.7526597061983, -122.400442161487) | 10 | 3 | 8 | 28856 | 29 | ||||
193438 | 199593 | DPW Maintained 1 | Yucca gloriosa :: Spanish Dagger 126 | 1451 Rhode Island St | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 5 | 6012044.93423 | 2101620.11846 | 37.7513270053431 | -122.40118928678 | (37.7513270053431, -122.40118928678) | 10 | 3 | 8 | 28856 | 29 | ||||
191233 | 199602 | DPW Maintained 1 | Yucca gloriosa :: Spanish Dagger 126 | 628 Missouri St | 1 | Sidewalk: Curb side : Pot | Tree | Private 2 | 9 | 6013530.55815 | 2104182.03337 | 37.7584442391246 | -122.396231328824 | (37.7584442391246, -122.396231328824) | 10 | 3 | 8 | 28856 | 29 | ||||
189662 | 246642 | DPW Maintained 1 | Yucca gloriosa :: Spanish Dagger 126 | 3350 Harrison St | 3 | Side Yard : Yard | Tree | Private 2 | 11 | 6009030.51293 | 2099210.21196 | 37.7445413057285 | -122.411443301892 | (37.7445413057285, -122.411443301892) | 2 | 7 | 7 | 28859 | 2 | ||||
189321 | 217533 | DPW Maintained 1 | Yucca gloriosa :: Spanish Dagger 126 | 167 Vernon St | 2 | Sidewalk: Property side : Yard | Tree | Private 2 | 22 | Width 10ft | 5992432.25049 | 2088990.35814 | 37.7155351614814 | -122.468092986116 | (37.7155351614814, -122.468092986116) | 9 | 8 | 6 | 64 | 24 | |||
188312 | 90717 | DPW Maintained 1 | Yucca gloriosa :: Spanish Dagger 126 | 4600X Cabrillo St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 04/07/2008 12:00:00 AM | 3 | 3x3 | 5981323.93536 | 2110313.64162 | 37.7734351649753 | -122.508069300521 | (37.7734351649753, -122.508069300521) | 11 | 6 | 2 | 55 | 26 | ||
187155 | 247590 | DPW Maintained 1 | Yucca gloriosa :: Spanish Dagger 126 | 800 Tompkins Ave | 11 | Front Yard : Yard | Tree | Private 2 | 40 | 6008957.64855 | 2096444.89116 | 37.7369442521782 | -122.411499920492 | (37.7369442521782, -122.411499920492) | 10 | 7 | 7 | 28859 | 2 | ||||
187151 | 217535 | DPW Maintained 1 | Yucca gloriosa :: Spanish Dagger 126 | 385 Head St | 1 | Sidewalk: Curb side : Pot | Tree | Private 2 | 28 | Width 4ft | 5993463.79196 | 2088414.8734 | 37.7140145374208 | -122.464485782892 | (37.7140145374208, -122.464485782892) | 9 | 8 | 6 | 64 | 24 | |||
186956 | 199619 | DPW Maintained 1 | Yucca gloriosa :: Spanish Dagger 126 | 2399 Lane St | 5 | Side Yard : Yard | Tree | Private 2 | 22 | 6013984.3244 | 2092869.9258 | 37.7274087980523 | -122.393870163286 | (37.7274087980523, -122.393870163286) | 10 | 3 | 8 | 58 | 1 | ||||
186393 | 90712 | DPW Maintained 1 | Yucca gloriosa :: Spanish Dagger 126 | 4508 Cabrillo St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 04/07/2008 12:00:00 AM | 3 | 3x3 | 5981619.82432 | 2110323.60403 | 37.7734799493833 | -122.507046535321 | (37.7734799493833, -122.507046535321) | 11 | 6 | 2 | 55 | 26 | ||
186119 | 199519 | DPW Maintained 1 | Yucca gloriosa :: Spanish Dagger 126 | 575 San Bruno Ave | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 7 | Width 4ft | 6010977.45969 | 2105690.75221 | 37.7624444505698 | -122.405167364075 | (37.7624444505698, -122.405167364075) | 8 | 3 | 8 | 28856 | 29 | |||
185776 | 185260 | DPW Maintained 1 | Yucca gloriosa :: Spanish Dagger 126 | 2101 Vicente St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 0ft | 5986447.7621 | 2097526.8372 | 37.738626684671 | -122.489405101522 | (37.738626684671, -122.489405101522) | 1 | 8 | 3 | 29491 | 35 | |||
185320 | 90711 | DPW Maintained 1 | Yucca gloriosa :: Spanish Dagger 126 | 4500 Cabrillo St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 04/07/2008 12:00:00 AM | 3 | 3x3 | 5981635.19797 | 2110323.94692 | 37.773481796264 | -122.506993382003 | (37.773481796264, -122.506993382003) | 11 | 6 | 2 | 55 | 26 | ||
184227 | 243966 | DPW Maintained 1 | Yucca gloriosa :: Spanish Dagger 126 | 1001 San Jose Ave | 3 | Sidewalk: Curb side : Yard | Tree | Private 2 | 7 | Width 10ft | 6005137.774 | 2096747.60933 | 37.7375604469531 | -122.424728467557 | (37.7375604469531, -122.424728467557) | 2 | 7 | 5 | 28859 | 2 | |||
183169 | 199584 | DPW Maintained 1 | Yucca gloriosa :: Spanish Dagger 126 | 889 Vermont St | 7 | Sidewalk: Curb side : Yard | Tree | Private 2 | 4 | 6011329.43673 | 2104204.01823 | 37.7583818819269 | -122.403845375987 | (37.7583818819269, -122.403845375987) | 10 | 3 | 8 | 28856 | 29 | ||||
181626 | 199521 | DPW Maintained 1 | Yucca gloriosa :: Spanish Dagger 126 | 1112 Tennessee St | 3 | Sidewalk: Curb side : Pot | Tree | Private 2 | 58 | Width 6ft | 6015518.58105 | 2103812.19357 | 37.7575391569355 | -122.389329974622 | (37.7575391569355, -122.389329974622) | 10 | 3 | 8 | 28856 | 29 | |||
181486 | 90686 | DPW Maintained 1 | Yucca gloriosa :: Spanish Dagger 126 | 4000X Cabrillo St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 04/07/2008 12:00:00 AM | 3 | 3x3 | 5983182.62546 | 2110378.74421 | 37.7737232641716 | -122.501644747223 | (37.7737232641716, -122.501644747223) | 11 | 6 | 2 | 55 | 26 | ||
181126 | 121634 | DPW Maintained 1 | Yucca gloriosa :: Spanish Dagger 126 | 349 17th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | 3x3 | 5990532 | 2113054 | 37.7814977082044 | -122.476417841695 | (37.7814977082044, -122.476417841695) | 11 | 6 | 2 | 55 | 26 | |||
180454 | 181303 | DPW Maintained 1 | Yucca gloriosa :: Spanish Dagger 126 | 101 Nueva Ave | 6 | Front Yard : Yard | Tree | Private 2 | 15 | Width 4ft | 6013062.58437 | 2087561.0422 | 37.712780400456 | -122.396684633014 | (37.712780400456, -122.396684633014) | 10 | 3 | 8 | 58 | 1 | |||
180429 | 244012 | DPW Maintained 1 | Yucca gloriosa :: Spanish Dagger 126 | 1327 Diamond St | 2 | Sidewalk: Property side : Yard | Tree | Private 2 | 85 | Width 10ft | 6002018.1444 | 2100161.75754 | 37.7467582119217 | -122.435758689308 | (37.7467582119217, -122.435758689308) | 2 | 7 | 5 | 63 | 22 | |||
180066 | 243994 | DPW Maintained 1 | Yucca gloriosa :: Spanish Dagger 126 | 488 29th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 40 | Width 3ft | 6003420.04437 | 2098951.19234 | 37.7435138132165 | -122.430824682119 | (37.7435138132165, -122.430824682119) | 2 | 7 | 5 | 63 | 22 | |||
179874 | 182636 | DPW Maintained 1 | Yucca gloriosa :: Spanish Dagger 126 | 1634 Ortega St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 0ft | 5988875.299 | 2102432.4985 | 37.7522377520489 | -122.481371089356 | (37.7522377520489, -122.481371089356) | 1 | 8 | 3 | 56 | 35 | |||
179199 | 199564 | DPW Maintained 1 | Yucca gloriosa :: Spanish Dagger 126 | 601 Wisconsin St | 14 | Sidewalk: Curb side : Yard | Tree | Private 2 | 25 | Width 3ft | 6012717.45668 | 2104647.64454 | 37.7596774282013 | -122.399076095796 | (37.7596774282013, -122.399076095796) | 10 | 3 | 8 | 28856 | 29 | |||
178445 | 243997 | DPW Maintained 1 | Yucca gloriosa :: Spanish Dagger 126 | 483 Valley St | 13 | Sidewalk: Curb side : Yard | Tree | Private 2 | 15 | 6002856.13849 | 2099166.37305 | 37.7440726834043 | -122.432789895044 | (37.7440726834043, -122.432789895044) | 2 | 7 | 5 | 63 | 22 | ||||
178286 | 199594 | DPW Maintained 1 | Yucca gloriosa :: Spanish Dagger 126 | 1441 Rhode Island St | 2 | Sidewalk: Property side : Yard | Tree | Private 2 | 13 | Width 3ft | 6012053.10974 | 2101657.49367 | 37.751430085644 | -122.401163640783 | (37.751430085644, -122.401163640783) | 10 | 3 | 8 | 28856 | 29 | |||
178235 | 243979 | DPW Maintained 1 | Yucca gloriosa :: Spanish Dagger 126 | 1201 San Jose Ave | 78 | Front Yard : Yard | Tree | Private 2 | 13 | 6004594.17707 | 2096179.38026 | 37.735969501297 | -122.426567490311 | (37.735969501297, -122.426567490311) | 2 | 7 | 5 | 28861 | 2 | ||||
177151 | 119238 | DPW Maintained 1 | Yucca gloriosa :: Spanish Dagger 126 | 4701 Cabrillo St | 2 | Sidewalk: Property side : Yard | Tree | Private 2 | 6 | Width 3ft | 5980953.58736 | 2110230.22563 | 37.7731842998171 | -122.509344168 | (37.7731842998171, -122.509344168) | 11 | 6 | 2 | 55 | 26 | |||
177002 | 181291 | DPW Maintained 1 | Yucca gloriosa :: Spanish Dagger 126 | 290 Foote Ave | 3 | Sidewalk: Property side : Yard | Tree | Private 2 | 8 | Width 4ft | 5998263.62341 | 2088768.79624 | 37.7152618512359 | -122.447921283438 | (37.7152618512359, -122.447921283438) | 9 | 7 | 6 | 28861 | 25 | |||
176359 | 118684 | DPW Maintained 1 | Yucca gloriosa :: Spanish Dagger 126 | 684 48th Ave | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 3 | Width 2ft | 5981039.03921 | 2111092.68807 | 37.7755574057413 | -122.509112640728 | (37.7755574057413, -122.509112640728) | 11 | 6 | 2 | 55 | 26 | |||
175215 | 217529 | DPW Maintained 1 | Yucca gloriosa :: Spanish Dagger 126 | 1x Minerva St | 24 | Median : Cutout | Tree | DPW 1 | 24 | Width 0ft | 5996247.03619 | 2089001.79824 | 37.7157861460877 | -122.454908274716 | (37.7157861460877, -122.454908274716) | 9 | 8 | 6 | 28861 | 24 | |||
175137 | 119670 | Undocumented 4 | Yucca gloriosa :: Spanish Dagger 126 | 699x Missouri St | 11 | Sidewalk: Property side : Yard | Tree | Private 2 | 6013712 | 2104098 | 37.7582235960409 | -122.395597929962 | (37.7582235960409, -122.395597929962) | 10 | 3 | 8 | 28856 | 29 | |||||
174973 | 199573 | DPW Maintained 1 | Yucca gloriosa :: Spanish Dagger 126 | 1399 De Haro St | 4 | Sidewalk: Curb side : Pot | Tree | Private 2 | 9 | 6012315.17384 | 2101950.7126 | 37.7522498176817 | -122.400277978566 | (37.7522498176817, -122.400277978566) | 10 | 3 | 8 | 28856 | 29 | ||||
174970 | 217493 | DPW Maintained 1 | Yucca gloriosa :: Spanish Dagger 126 | 1501 15th Ave | 3 | Front Yard : Yard | Tree | Private 2 | 24 | 5991534.00074 | 2105121.21234 | 37.7597744749213 | -122.472372960446 | (37.7597744749213, -122.472372960446) | 1 | 8 | 4 | 56 | 12 | ||||
174734 | 90710 | DPW Maintained 1 | Yucca gloriosa :: Spanish Dagger 126 | 4450 Cabrillo St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 04/07/2008 12:00:00 AM | 3 | 3x3 | 5981744.51954 | 2110327.15127 | 37.773497032089 | -122.50661546708 | (37.773497032089, -122.50661546708) | 11 | 6 | 2 | 55 | 26 | ||
174708 | 217520 | DPW Maintained 1 | Yucca gloriosa :: Spanish Dagger 126 | 278 Granada Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 3ft | 5995672.48262 | 2091833.70797 | 37.7235289240095 | -122.457098912596 | (37.7235289240095, -122.457098912596) | 9 | 8 | 4 | 28861 | 24 | |||
174429 | 246779 | DPW Maintained 1 | Yucca gloriosa :: Spanish Dagger 126 | 398 Franconia St | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 4 | Width 8ft | 6009874.45509 | 2098802.14563 | 37.7434681447548 | -122.408496327841 | (37.7434681447548, -122.408496327841) | 2 | 7 | 7 | 28859 | 2 | |||
174323 | 199523 | DPW Maintained 1 | Yucca gloriosa :: Spanish Dagger 126 | 1150x Tennessee St | 4 | Median : Cutout | Tree | DPW 1 | 9 | Width 4ft | 6015556.62319 | 2103663.95863 | 37.7571342443646 | -122.389188058008 | (37.7571342443646, -122.389188058008) | 10 | 3 | 8 | 28856 | 29 | |||
173339 | 183491 | DPW Maintained 1 | Yucca gloriosa :: Spanish Dagger 126 | 2526 32nd Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 0ft | 5986467.9493 | 2098039.2717 | 37.7400348721869 | -122.48937297276 | (37.7400348721869, -122.48937297276) | 1 | 8 | 3 | 29491 | 35 | |||
173215 | 199566 | DPW Maintained 1 | Yucca gloriosa :: Spanish Dagger 126 | 1512 25th St | 3 | Sidewalk: Property side : Yard | Tree | Private 2 | 22 | Width 9ft | 6014108.69485 | 2102017.75026 | 37.7525337354666 | -122.394080346538 | (37.7525337354666, -122.394080346538) | 10 | 3 | 8 | 28856 | 29 | |||
172745 | 243964 | DPW Maintained 1 | Yucca gloriosa :: Spanish Dagger 126 | 979 San Bruno Ave | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 4 | Width 6ft | 6011092.59342 | 2103787.62329 | 37.7572253196086 | -122.40463517678 | (37.7572253196086, -122.40463517678) | 10 | 4 | 8 | 28859 | 19 | |||
172744 | 182688 | DPW Maintained 1 | Yucca gloriosa :: Spanish Dagger 126 | 1706 36th Ave | 2 | Sidewalk: Curb side : Yard | Tree | Private 2 | 3 | Width 0ft | 5985037.7029 | 2103552.115 | 37.7550880417782 | -122.494724439177 | (37.7550880417782, -122.494724439177) | 1 | 8 | 3 | 56 | 35 | |||
172208 | 217518 | DPW Maintained 1 | Yucca gloriosa :: Spanish Dagger 126 | 124 Marston Ave | 4 | Sidewalk: Property side : Yard | Tree | Private 2 | 11 | 5998600.75769 | 2093225.60072 | 37.7275184703858 | -122.447076550251 | (37.7275184703858, -122.447076550251) | 9 | 7 | 4 | 28861 | 40 | ||||
170277 | 199604 | DPW Maintained 1 | Yucca gloriosa :: Spanish Dagger 126 | 630 Missouri St | 1 | Sidewalk: Curb side : Pot | Tree | Private 2 | 13 | 6013529.78506 | 2104152.57114 | 37.7583632992371 | -122.396231937657 | (37.7583632992371, -122.396231937657) | 10 | 3 | 8 | 28856 | 29 | ||||
170144 | 199607 | DPW Maintained 1 | Yucca gloriosa :: Spanish Dagger 126 | 1515 19th St | 3 | : | Tree | Private 2 | 23 | Width 4ft | 6013161.794 | 2105177.42941 | 37.7611568525187 | -122.397576500574 | (37.7611568525187, -122.397576500574) | 10 | 3 | 8 | 28856 | 29 | |||
170044 | 199605 | DPW Maintained 1 | Yucca gloriosa :: Spanish Dagger 126 | 651 Missouri St | 27 | Sidewalk: Property side : Yard | Tree | Private 2 | 35 | 6013602.02772 | 2104054.17781 | 37.7580971520802 | -122.395975193824 | (37.7580971520802, -122.395975193824) | 10 | 3 | 8 | 28856 | 29 | ||||
169978 | 141021 | DPW Maintained 1 | Yucca gloriosa :: Spanish Dagger 126 | 160 Anza St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 0ft | 5998570.6909 | 2112701.5936 | 37.7809930194286 | -122.448582571297 | (37.7809930194286, -122.448582571297) | 15 | 6 | 2 | 54 | 16 | |||
169737 | 199583 | DPW Maintained 1 | Yucca gloriosa :: Spanish Dagger 126 | 889 Vermont St | 6 | Sidewalk: Curb side : Yard | Tree | Private 2 | 6 | 6011324.46991 | 2104197.94013 | 37.7583649153354 | -122.403862125843 | (37.7583649153354, -122.403862125843) | 10 | 3 | 8 | 28856 | 29 | ||||
169184 | 243988 | DPW Maintained 1 | Yucca gloriosa :: Spanish Dagger 126 | 2766 23rd St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 15 | Width 3ft | 6010155.45167 | 2102831.44612 | 37.754547449722 | -122.407808770075 | (37.754547449722, -122.407808770075) | 2 | 4 | 7 | 28859 | 19 | |||
168884 | 199549 | DPW Maintained 1 | Yucca gloriosa :: Spanish Dagger 126 | 1 01st St | 5 | : Yard | Tree | Private 2 | 9 | 6014392.26095 | 2105920.87265 | 37.7632666242892 | -122.393372837314 | (37.7632666242892, -122.393372837314) | 14 | 3 | 8 | 28856 | 29 | ||||
168539 | 181297 | DPW Maintained 1 | Yucca gloriosa :: Spanish Dagger 126 | 271 Prague St | 2 | Sidewalk: Property side : Yard | Tree | Private 2 | 14 | Width 8ft | 6004070.03607 | 2089576.37759 | 37.7178094785893 | -122.427909293206 | (37.7178094785893, -122.427909293206) | 9 | 7 | 6 | 28861 | 5 | |||
168037 | 199591 | DPW Maintained 1 | Yucca gloriosa :: Spanish Dagger 126 | 2250 26th St | 5 | Sidewalk: Curb side : Yard | Tree | Private 2 | 12 | 6011839.26664 | 2101391.56211 | 37.7506879632992 | -122.401884448303 | (37.7506879632992, -122.401884448303) | 10 | 3 | 8 | 28856 | 29 | ||||
165586 | 182104 | DPW Maintained 1 | Yucca gloriosa :: Spanish Dagger 126 | 2434 28th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 0ft | 5987687.8918 | 2098712.0823 | 37.7419533724178 | -122.485204320572 | (37.7419533724178, -122.485204320572) | 1 | 8 | 3 | 29491 | 35 | |||
164125 | 243995 | DPW Maintained 1 | Yucca gloriosa :: Spanish Dagger 126 | 483 Valley St | 7 | Sidewalk: Curb side : Yard | Tree | Private 2 | 11 | 6002806.73201 | 2099162.00018 | 37.7440578742739 | -122.432960419114 | (37.7440578742739, -122.432960419114) | 2 | 7 | 5 | 63 | 22 | ||||
163845 | 181308 | DPW Maintained 1 | Yucca gloriosa :: Spanish Dagger 126 | 36 Ramsell St | 2 | Sidewalk: Property side : Yard | Tree | Private 2 | 4 | Width 6ft | 5992982.57261 | 2087488.714 | 37.7114437731934 | -122.466081784571 | (37.7114437731934, -122.466081784571) | 9 | 8 | 4 | 64 | 24 | |||
163809 | 253980 | DPW Maintained 1 | Yucca gloriosa :: Spanish Dagger 126 | 433 Detroit St | 2 | Sidewalk: Curb side : Pot | Tree | Private 2 | Width 10ft | 5999422.35392 | 2094544.1981 | 37.7311859389748 | -122.444331015365 | (37.7311859389748, -122.444331015365) | 9 | 7 | 4 | 59 | 40 | ||||
163671 | 46635 | DPW Maintained 1 | Yucca gloriosa :: Spanish Dagger 126 | 1571 Underwood Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 04/12/2002 12:00:00 AM | 3 | Permit Number 44756 | 6014716.9997 | 2093587.5042 | 37.7294198145801 | -122.391387425418 | (37.7294198145801, -122.391387425418) | 10 | 3 | 8 | 58 | 1 | |
163621 | 92398 | DPW Maintained 1 | Yucca gloriosa :: Spanish Dagger 126 | 1919 22nd St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/29/2009 12:00:00 AM | 12 | 3x3 | Permit Number 52800 | 6012329.06895 | 2103729.70142 | 37.7571353073613 | -122.400354868801 | (37.7571353073613, -122.400354868801) | 10 | 3 | 8 | 28856 | 29 | |
163229 | 91014 | DPW Maintained 1 | Yucca gloriosa :: Spanish Dagger 126 | 4139 Cabrillo St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 11/24/2008 12:00:00 AM | 3 | 3x3 | 5982669.85077 | 2110306.16826 | 37.7734938602238 | -122.503413110518 | (37.7734938602238, -122.503413110518) | 11 | 6 | 2 | 55 | 26 | ||
161849 | 117833 | DPW Maintained 1 | Yucca gloriosa :: Spanish Dagger 126 | 822 39th Ave | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 4 | Width 3ft | 5983882.02568 | 2110188.1448 | 37.7732409879174 | -122.499211363837 | (37.7732409879174, -122.499211363837) | 11 | 6 | 2 | 55 | 26 | |||
161586 | 243971 | DPW Maintained 1 | Yucca gloriosa :: Spanish Dagger 126 | 336 Elsie St | 3 | Sidewalk: Property side : Yard | Tree | Private 2 | 12 | Width 5ft | 6006473.44341 | 2097229.56707 | 37.7389591427554 | -122.420144611411 | (37.7389591427554, -122.420144611411) | 2 | 7 | 7 | 28859 | 2 | |||
160694 | 199610 | DPW Maintained 1 | Yucca gloriosa :: Spanish Dagger 126 | 1800 Illinois St | 5 | Sidewalk: Property side : Yard | Tree | Private 2 | 19 | Width 7ft | 6016248.6287 | 2100650.91711 | 37.7488994014987 | -122.386584722116 | (37.7488994014987, -122.386584722116) | 10 | 3 | 8 | 58 | 1 | |||
160457 | 118619 | DPW Maintained 1 | Yucca gloriosa :: Spanish Dagger 126 | 498 47th Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 3ft | 5981321.44116 | 2112409.25336 | 37.7791889500721 | -122.508233505359 | (37.7791889500721, -122.508233505359) | 11 | 6 | 2 | 55 | 26 | |||
158913 | 199562 | DPW Maintained 1 | Yucca gloriosa :: Spanish Dagger 126 | 601 Wisconsin St | 8 | Sidewalk: Curb side : Yard | Tree | Private 2 | 30 | Width 3ft | 6012719.76904 | 2104617.31298 | 37.7595942732681 | -122.399065969425 | (37.7595942732681, -122.399065969425) | 10 | 3 | 8 | 28856 | 29 | |||
158481 | 217505 | DPW Maintained 1 | Yucca gloriosa :: Spanish Dagger 126 | 427 Flood Ave | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 28 | Width 8ft | 5997901.29894 | 2094070.44496 | 37.7297982247853 | -122.449555423544 | (37.7297982247853, -122.449555423544) | 9 | 7 | 4 | 28861 | 40 | |||
157827 | 202079 | DPW Maintained 1 | Yucca gloriosa :: Spanish Dagger 126 | 1 Gould St | 8 | Front Yard : Yard | Tree | Private 2 | 10 | 6012746.01501 | 2090845.03433 | 37.721779962063 | -122.398009040306 | (37.721779962063, -122.398009040306) | 10 | 3 | 8 | 58 | 1 | ||||
157486 | 199536 | DPW Maintained 1 | Yucca gloriosa :: Spanish Dagger 126 | 101 Pennsylvania Ave | 13 | Front Yard : Yard | Tree | Private 2 | 4 | 6014326.65854 | 2106427.77469 | 37.7646548213741 | -122.3936352163 | (37.7646548213741, -122.3936352163) | 14 | 3 | 8 | 310 | 29 | ||||
157103 | 217496 | DPW Maintained 1 | Yucca gloriosa :: Spanish Dagger 126 | 129 Merced Ave | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 4ft | 5994601.19154 | 2099478.10062 | 37.7444569673245 | -122.461356045958 | (37.7444569673245, -122.461356045958) | 1 | 8 | 4 | 59 | 40 | |||
157080 | 137509 | DPW Maintained 1 | Yucca gloriosa :: Spanish Dagger 126 | 85 Toledo Way | 1 | Sidewalk: Curb side : Pot | Tree | Private 2 | 6 | Width 3ft | 6001461.48208 | 2119936.52079 | 37.8010231216701 | -122.439100597914 | (37.8010231216701, -122.439100597914) | 13 | 9 | 1 | 57 | 17 | |||
157049 | 181304 | DPW Maintained 1 | Yucca gloriosa :: Spanish Dagger 126 | 700 Brussels St | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 5 | Width 10ft | 6010994.40429 | 2091467.52457 | 37.7233914797163 | -122.404107722615 | (37.7233914797163, -122.404107722615) | 10 | 3 | 7 | 309 | 28 | |||
156896 | 243982 | DPW Maintained 1 | Yucca gloriosa :: Spanish Dagger 126 | 200 Kingston St | 16 | Front Yard : Yard | Tree | Private 2 | 3 | 6006211.87378 | 2098086.29455 | 37.741296782931 | -122.421109815985 | (37.741296782931, -122.421109815985) | 2 | 7 | 7 | 28859 | 2 | ||||
156813 | 117951 | DPW Maintained 1 | Yucca gloriosa :: Spanish Dagger 126 | 4101 Cabrillo St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | Width 3ft | 5982854.39017 | 2110311.68646 | 37.7735198584795 | -122.502775180908 | (37.7735198584795, -122.502775180908) | 11 | 6 | 2 | 55 | 26 | |||
156190 | 90736 | DPW Maintained 1 | Yucca gloriosa :: Spanish Dagger 126 | 4501X Cabrillo St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 04/07/2008 12:00:00 AM | 3 | 3x3 | 5981602.49176 | 2110266.28486 | 37.77332154692 | -122.507102237161 | (37.77332154692, -122.507102237161) | 11 | 6 | 2 | 55 | 26 | ||
155705 | 117778 | DPW Maintained 1 | Yucca gloriosa :: Spanish Dagger 126 | 7414 Geary Blvd | 2 | Sidewalk: Property side : Yard | Tree | Private 2 | 15 | Width 3ft | 5983986.79106 | 2112513.36972 | 37.7796315288324 | -122.499020803345 | (37.7796315288324, -122.499020803345) | 11 | 6 | 2 | 55 | 26 | |||
155531 | 199551 | DPW Maintained 1 | Yucca gloriosa :: Spanish Dagger 126 | 1 01st St | 7 | : Yard | Tree | Private 2 | 15 | 6014408.59689 | 2105921.94262 | 37.7632704697891 | -122.393316411129 | (37.7632704697891, -122.393316411129) | 14 | 3 | 8 | 28856 | 29 | ||||
155221 | 137510 | DPW Maintained 1 | Yucca gloriosa :: Spanish Dagger 126 | 85 Toledo Way | 3 | Sidewalk: Curb side : Pot | Tree | Private 2 | 6 | Width 3ft | 6001467.72221 | 2119937.03312 | 37.8010248834562 | -122.439079041178 | (37.8010248834562, -122.439079041178) | 13 | 9 | 1 | 57 | 17 | |||
155031 | 244014 | DPW Maintained 1 | Yucca gloriosa :: Spanish Dagger 126 | 74 Newburg St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 24 | Width 2ft | 6002331.24363 | 2099784.70156 | 37.745740684777 | -122.434649067111 | (37.745740684777, -122.434649067111) | 2 | 7 | 5 | 63 | 22 | |||
154776 | 118206 | DPW Maintained 1 | Yucca gloriosa :: Spanish Dagger 126 | 599 35th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 3ft | 5985063.76803 | 2111840.93131 | 37.7778483216089 | -122.495245527349 | (37.7778483216089, -122.495245527349) | 11 | 6 | 2 | 55 | 26 | |||
154704 | 199596 | DPW Maintained 1 | Yucca gloriosa :: Spanish Dagger 126 | 1700 22nd St | 4 | Front Yard : Yard | Tree | Private 2 | 5 | 6012934.13528 | 2103807.83059 | 37.7573835553253 | -122.398267784253 | (37.7573835553253, -122.398267784253) | 10 | 3 | 8 | 28856 | 29 | ||||
154627 | 137507 | DPW Maintained 1 | Yucca gloriosa :: Spanish Dagger 126 | 1920 Beach St | 4 | Sidewalk: Property side : Yard | Tree | Private 2 | 30 | Width 6ft | 6001011.39316 | 2121024.38101 | 37.8039844758743 | -122.440736171548 | (37.8039844758743, -122.440736171548) | 13 | 9 | 1 | 57 | 17 | |||
154400 | 184419 | DPW Maintained 1 | Yucca gloriosa :: Spanish Dagger 126 | 3715 Quintara St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 0ft | 5981926.4298 | 2100773.5787 | 37.7472763594104 | -122.505278014143 | (37.7472763594104, -122.505278014143) | 1 | 8 | 3 | 29491 | 35 | |||
153191 | 37145 | DPW Maintained 1 | Yucca gloriosa :: Spanish Dagger 126 | 755 48th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/04/1998 12:00:00 AM | 4 | Permit Number 39727 | 5981030.6614 | 2110569.17364 | 37.7741194954723 | -122.509102737692 | (37.7741194954723, -122.509102737692) | 11 | 6 | 2 | 55 | 26 | ||
152688 | 244007 | DPW Maintained 1 | Yucca gloriosa :: Spanish Dagger 126 | 784 Duncan St | 5 | Sidewalk: Property side : Yard | Tree | Private 2 | 3 | Width 6ft | 6001417.55877 | 2099722.5015 | 37.7455179856587 | -122.437803995867 | (37.7455179856587, -122.437803995867) | 2 | 7 | 5 | 63 | 22 | |||
152558 | 120084 | DPW Maintained 1 | Yucca gloriosa :: Spanish Dagger 126 | 401 26th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 3ft | 5987761.35278 | 2113240.07553 | 37.7818475445369 | -122.486016488538 | (37.7818475445369, -122.486016488538) | 11 | 6 | 2 | 55 | 26 | |||
151620 | 246743 | DPW Maintained 1 | Yucca gloriosa :: Spanish Dagger 126 | 140 Ripley St | 1 | Front Yard : Yard | Tree | Private 2 | 12 | 6008904.95931 | 2099075.94101 | 37.7441655842699 | -122.411867956365 | (37.7441655842699, -122.411867956365) | 2 | 7 | 7 | 28859 | 2 | ||||
150653 | 243967 | DPW Maintained 1 | Yucca gloriosa :: Spanish Dagger 126 | 1100 San Jose Ave | 11 | Front Yard : Yard | Tree | Private 2 | 5 | 6004821.13664 | 2096702.54492 | 37.7374188217218 | -122.425820026897 | (37.7374188217218, -122.425820026897) | 2 | 7 | 5 | 63 | 7 | ||||
149914 | 199580 | DPW Maintained 1 | Yucca gloriosa :: Spanish Dagger 126 | 920 Vermont St | 2 | Sidewalk: Curb side : Yard | Tree | Private 2 | 15 | Width 10ft | 6011326.45045 | 2104017.48504 | 37.7578695363793 | -122.403842578193 | (37.7578695363793, -122.403842578193) | 10 | 3 | 8 | 28856 | 29 | |||
149299 | 117696 | DPW Maintained 1 | Yucca gloriosa :: Spanish Dagger 126 | 4049 Clement St | 3 | Sidewalk: Property side : Yard | Tree | Private 2 | 9 | Width 7ft | 5982902.7944 | 2113073.38383 | 37.7811055179679 | -122.502812220234 | (37.7811055179679, -122.502812220234) | 11 | 6 | 2 | 55 | 26 | |||
149096 | 51651 | DPW Maintained 1 | Yucca gloriosa :: Spanish Dagger 126 | 570 42nd Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 03/16/2005 12:00:00 AM | 16 | Permit Number 47934 | 5982889.2977 | 2111913.98983 | 37.7779213685412 | -122.502773063589 | (37.7779213685412, -122.502773063589) | 11 | 6 | 2 | 55 | 26 | ||
148793 | 90739 | DPW Maintained 1 | Yucca gloriosa :: Spanish Dagger 126 | 4451X Cabrillo St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 04/07/2008 12:00:00 AM | 3 | 3x3 | 5981746.10841 | 2110271.13179 | 37.7733433125324 | -122.50660581555 | (37.7733433125324, -122.50660581555) | 11 | 6 | 2 | 55 | 26 | ||
148756 | 199587 | DPW Maintained 1 | Yucca gloriosa :: Spanish Dagger 126 | 875 Vermont St | 9 | Sidewalk: Curb side : Yard | Tree | Private 2 | 5 | 6011307.00123 | 2104284.0502 | 37.7586003785102 | -122.403928600141 | (37.7586003785102, -122.403928600141) | 10 | 3 | 8 | 28856 | 29 | ||||
146799 | 117950 | DPW Maintained 1 | Yucca gloriosa :: Spanish Dagger 126 | 4045 Cabrillo St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 3ft | 5983004.75382 | 2110316.66923 | 37.7735423752614 | -122.50225542827 | (37.7735423752614, -122.50225542827) | 11 | 6 | 2 | 55 | 26 | |||
145630 | 199544 | DPW Maintained 1 | Yucca gloriosa :: Spanish Dagger 126 | 101 Pennsylvania Ave | 42 | Front Yard : Yard | Tree | Private 2 | 4 | 6014223.58604 | 2106699.16409 | 37.7653942691555 | -122.394010719216 | (37.7653942691555, -122.394010719216) | 14 | 3 | 8 | 28856 | 20 | ||||
145566 | 122074 | DPW Maintained 1 | Yucca gloriosa :: Spanish Dagger 126 | 347 17th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11 | Width 3ft | 5990561.10649 | 2113058.51415 | 37.7815117908068 | -122.476317478147 | (37.7815117908068, -122.476317478147) | 11 | 6 | 2 | 55 | 26 | |||
145450 | 181299 | DPW Maintained 1 | Yucca gloriosa :: Spanish Dagger 126 | 57 Cross St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 51 | Width 2ft | 5999982.25069 | 2088153.56575 | 37.7136706537558 | -122.44193684201 | (37.7136706537558, -122.44193684201) | 9 | 7 | 6 | 28861 | 5 | |||
144992 | 253609 | DPW Maintained 1 | Yucca gloriosa :: Spanish Dagger 126 | 318 Utah St | 2 | Front Yard : Yard | Tree | Private 2 | Width 4ft | Permit Number 780845 | 6010580.39617 | 2106780.39752 | 37.7654141639451 | -122.406617457953 | (37.7654141639451, -122.406617457953) | 8 | 4 | 8 | 28853 | 19 | |||
144904 | 181310 | DPW Maintained 1 | Yucca gloriosa :: Spanish Dagger 126 | 3001 Ocean Ave | 3 | : | Tree | Private 2 | 3 | Width 3ft | 5989516.32728 | 2095227.01255 | 37.7324906133438 | -122.478627441312 | (37.7324906133438, -122.478627441312) | 1 | 8 | 4 | 64 | 35 | |||
144286 | 181307 | DPW Maintained 1 | Yucca gloriosa :: Spanish Dagger 126 | 36 Ramsell St | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 8 | Width 6ft | 5992982.17561 | 2087469.81954 | 37.7113918706115 | -122.466081784562 | (37.7113918706115, -122.466081784562) | 9 | 8 | 4 | 64 | 24 | |||
144256 | 243981 | DPW Maintained 1 | Yucca gloriosa :: Spanish Dagger 126 | 1201 San Jose Ave | 80 | Front Yard : Yard | Tree | Private 2 | 11 | 6004609.84648 | 2096189.0617 | 37.7359969701789 | -122.426514004025 | (37.7359969701789, -122.426514004025) | 2 | 7 | 5 | 28861 | 2 | ||||
144206 | 98817 | DPW Maintained 1 | Yucca gloriosa :: Spanish Dagger 126 | 290 Napoleon St | 8 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 25 | 3x3 | 6011799.60927 | 2099715.83427 | 37.7460845639436 | -122.401903804432 | (37.7460845639436, -122.401903804432) | 10 | 3 | 8 | 58 | 1 |
Advanced export
JSON shape: default, array, newline-delimited, object
CREATE TABLE "trees" ( [rowid] INTEGER PRIMARY KEY, [TreeID] TEXT, [qLegalStatus_id] INTEGER REFERENCES [qLegalStatus]([id]), [qSpecies_id] INTEGER, [qAddress] TEXT, [SiteOrder] TEXT, [qSiteInfo] TEXT, [PlantType] TEXT, [qCaretaker_id] INTEGER REFERENCES [qCaretaker]([id]), [qCareAssistant] TEXT, [PlantDate] TEXT, [DBH] TEXT, [PlotSize] TEXT, [PermitNotes] TEXT, [XCoord] TEXT, [YCoord] TEXT, [Latitude] TEXT, [Longitude] TEXT, [Location] TEXT, [Fire Prevention Districts] TEXT, [Police Districts] TEXT, [Supervisor Districts] TEXT, [Zip Codes] TEXT, [Neighborhoods (old)] TEXT, FOREIGN KEY(qSpecies_id) REFERENCES qSpecies(id) );