trees
3,247 rows where qSpecies_id = 22 sorted by Neighborhoods (old) 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) ▲ |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 54657 | 60664 | Permitted Site 7 | Ginkgo biloba :: Maidenhair Tree 22 | 249 Whitney St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 02/12/1983 12:00:00 AM | Permit Number 20298 | 6004405.0967778 | 2096932.39684696 | 37.7380264232829 | -122.427274839887 | (37.7380264232829, -122.427274839887) | 2 | 7 | 5 | 63 | 7 | ||
| 59114 | 5739 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 1747 Dolores St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 60 | 3X3 | 6005368.01373 | 2098244.45158 | 37.7416834392278 | -122.424038834141 | (37.7416834392278, -122.424038834141) | 2 | 7 | 5 | 28859 | 7 | |||
| 65538 | 225619 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 51 Lippard Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 2ft | 6002034.44576 | 2095916.26865 | 37.7351020152473 | -122.435398676334 | (37.7351020152473, -122.435398676334) | 2 | 7 | 5 | 63 | 7 | |||
| 68015 | 225614 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 53 Wilder St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 2ft | 6002564.50559 | 2095546.11614 | 37.7341157503395 | -122.433539626564 | (37.7341157503395, -122.433539626564) | 2 | 7 | 5 | 63 | 7 | |||
| 68239 | 38532 | Permitted Site 7 | Ginkgo biloba :: Maidenhair Tree 22 | 2473 Diamond St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 09/16/1998 12:00:00 AM | Permit Number 40514 | 6002133.61382428 | 2097290.82388735 | 37.7388818577796 | -122.435154099858 | (37.7388818577796, -122.435154099858) | 2 | 7 | 5 | 63 | 7 | |||
| 70700 | 228342 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 225 Randall St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 3ft | 6004124.16137 | 2097587.45021 | 37.739809158568 | -122.428292845936 | (37.739809158568, -122.428292845936) | 2 | 7 | 5 | 63 | 7 | |||
| 72483 | 225618 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 10 Lippard Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 3ft | 6002076.31903 | 2096053.65466 | 37.7354816235692 | -122.435263729452 | (37.7354816235692, -122.435263729452) | 2 | 7 | 5 | 63 | 7 | |||
| 72512 | 94675 | Permitted Site 7 | Ginkgo biloba :: Maidenhair Tree 22 | 595 Laidley St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 10/22/2010 12:00:00 AM | 3x3 | Permit Number 53811 | 6002917 | 2095871 | 37.735027800708 | -122.432344139463 | (37.735027800708, -122.432344139463) | 2 | 7 | 5 | 63 | 7 | |
| 73097 | 226303 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 53 Wilder St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 2ft | 6002497.61716 | 2095567.9464 | 37.7341718959041 | -122.433772440342 | (37.7341718959041, -122.433772440342) | 2 | 7 | 5 | 63 | 7 | |||
| 73980 | 228333 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 1860 Church St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 3ft | 6004567.46714 | 2097876.94226 | 37.7406291118418 | -122.426780691669 | (37.7406291118418, -122.426780691669) | 2 | 7 | 5 | 63 | 7 | |||
| 74894 | 228337 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 1768 Sanchez St | 1 | Sidewalk: Curb side : Pot | Tree | Private 2 | 2 | Width 2ft | 6003964.05943 | 2097961.58291 | 37.740827380874 | -122.428873076831 | (37.740827380874, -122.428873076831) | 2 | 7 | 5 | 63 | 7 | |||
| 77792 | 45781 | Permitted Site 7 | Ginkgo biloba :: Maidenhair Tree 22 | 15 Conrad St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 05/22/2002 12:00:00 AM | Permit Number 45510 | 6001863.57185125 | 2097043.59976445 | 37.7381876997157 | -122.436070091846 | (37.7381876997157, -122.436070091846) | 2 | 7 | 5 | 63 | 7 | ||
| 79431 | 119895 | Undocumented 4 | Ginkgo biloba :: Maidenhair Tree 22 | 542 Laidley St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6003120 | 2096087 | 37.7356323959743 | -122.431657713047 | (37.7356323959743, -122.431657713047) | 2 | 7 | 5 | 63 | 7 | ||||
| 80381 | 225617 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 203 Surrey St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 3ft | 6002059.36109 | 2096105.6654 | 37.7356234700408 | -122.435326078552 | (37.7356234700408, -122.435326078552) | 2 | 7 | 5 | 63 | 7 | |||
| 80731 | 4869 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 40 Crags Ct | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | 3X3 | 6000808.02248 | 2098114.83059 | 37.7410690233074 | -122.439796429476 | (37.7410690233074, -122.439796429476) | 2 | 7 | 5 | 63 | 7 | |||
| 85563 | 4879 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 72 Crags Ct | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/22/1992 12:00:00 AM | 20 | 3X3 | 6000878.30812 | 2097936.43992 | 37.7405832050459 | -122.4395406227 | (37.7405832050459, -122.4395406227) | 2 | 7 | 5 | 63 | 7 | ||
| 86118 | 4870 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 43 Crags Ct | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 02/04/2002 12:00:00 AM | 6 | 2X2 | 6000851.28277 | 2098123.40175 | 37.7410950200306 | -122.439647465779 | (37.7410950200306, -122.439647465779) | 2 | 7 | 5 | 63 | 7 | ||
| 86460 | 22839 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 112 Turquoise Way | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 05/01/2000 12:00:00 AM | 3 | 2X2 | 5999677.09263 | 2098954.86607 | 37.7433111213199 | -122.443767097286 | (37.7433111213199, -122.443767097286) | 2 | 7 | 5 | 63 | 7 | ||
| 86679 | 228334 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 65 Whitney St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 3ft | 6004308.16319 | 2097838.36972 | 37.740508536136 | -122.427674517971 | (37.740508536136, -122.427674517971) | 2 | 7 | 5 | 63 | 7 | |||
| 89821 | 102141 | Undocumented 4 | Ginkgo biloba :: Maidenhair Tree 22 | 53 Wilder St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/24/2012 12:00:00 AM | 3 | 2x3 | Permit Number 769415 | 6002570.6 | 2095528.3 | 37.7340671770771 | -122.433517283514 | (37.7340671770771, -122.433517283514) | 2 | 7 | 5 | 63 | 7 | |
| 92572 | 226043 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 1300 San Jose Ave | 6 | Front Yard : Yard | Tree | Private 2 | 6 | 6003683.45226 | 2095797.63784 | 37.7348697950059 | -122.429689011034 | (37.7348697950059, -122.429689011034) | 2 | 7 | 5 | 63 | 7 | ||||
| 95245 | 28106 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 43 Crags Ct | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | 2X3 | 6000839.27772 | 2098131.93516 | 37.7411177674645 | -122.439689586429 | (37.7411177674645, -122.439689586429) | 2 | 7 | 5 | 63 | 7 | |||
| 96852 | 88591 | Permitted Site 7 | Ginkgo biloba :: Maidenhair Tree 22 | 265 Chenery St | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/31/2008 12:00:00 AM | 3x3 | Permit Number 51536 | 6004525.2 | 2096785.5 | 37.7376298693918 | -122.42684912469 | (37.7376298693918, -122.42684912469) | 2 | 7 | 5 | 63 | 7 | |||
| 97842 | 226296 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 22 Roanoke St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 3ft | 6003303.86968 | 2096312.96894 | 37.7362632756258 | -122.431038128121 | (37.7362632756258, -122.431038128121) | 2 | 7 | 5 | 63 | 7 | |||
| 99689 | 226302 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 249 Whitney St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 3ft | 6004407.95276 | 2096972.47423 | 37.7381366282025 | -122.427267819364 | (37.7381366282025, -122.427267819364) | 2 | 7 | 5 | 63 | 7 | |||
| 101788 | 226295 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 448 Laidley St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 3ft | 6003536.17053 | 2096399.84236 | 37.7365149706945 | -122.430241164208 | (37.7365149706945, -122.430241164208) | 2 | 7 | 5 | 63 | 7 | |||
| 105666 | 226299 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 237 Miguel St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 3ft | 6004238.29103 | 2096709.22712 | 37.7374042149356 | -122.427835672874 | (37.7374042149356, -122.427835672874) | 2 | 7 | 5 | 63 | 7 | |||
| 111982 | 102142 | Undocumented 4 | Ginkgo biloba :: Maidenhair Tree 22 | 53 Wilder St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/24/2012 12:00:00 AM | 5 | 2x3 | Permit Number 769415 | 6002570.6 | 2095528.3 | 37.7340671770771 | -122.433517283514 | (37.7340671770771, -122.433517283514) | 2 | 7 | 5 | 63 | 7 | |
| 113314 | 226297 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 542 Laidley St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 04/20/2018 12:00:00 AM | 3 | Width 3ft | 6003133.29888 | 2096083.33285 | 37.7356230806238 | -122.431611472012 | (37.7356230806238, -122.431611472012) | 2 | 7 | 5 | 63 | 7 | ||
| 116845 | 4371 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 1006 Chenery St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/24/2011 12:00:00 AM | 3 | 3x3 | 6000975.48263 | 2096188.08245 | 37.7357881547849 | -122.439079358629 | (37.7357881547849, -122.439079358629) | 2 | 7 | 5 | 63 | 7 | ||
| 119877 | 116752 | Undocumented 4 | Ginkgo biloba :: Maidenhair Tree 22 | 542 LAIDLEY ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | 3x3 | 6003120 | 2096087 | 37.7356323959743 | -122.431657713047 | (37.7356323959743, -122.431657713047) | 2 | 7 | 5 | 63 | 7 | |||
| 122679 | 228340 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 527 30th St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 2ft | 6003227.90552 | 2098318.66443 | 37.7417661498904 | -122.431443904912 | (37.7417661498904, -122.431443904912) | 2 | 7 | 5 | 63 | 7 | |||
| 123838 | 91523 | Permitted Site 7 | Ginkgo biloba :: Maidenhair Tree 22 | 221 Randall St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/11/2009 12:00:00 AM | 3x3 | Permit Number 52127 | 6004144 | 2097575 | 37.739776095658 | -122.428223365233 | (37.739776095658, -122.428223365233) | 2 | 7 | 5 | 63 | 7 | ||
| 124005 | 228343 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 50 Everson St | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 1 | Width 3ft | 6003603.71357 | 2097148.2169 | 37.7385736618306 | -122.430061009332 | (37.7385736618306, -122.430061009332) | 2 | 7 | 5 | 63 | 7 | |||
| 124606 | 57089 | Permitted Site 7 | Ginkgo biloba :: Maidenhair Tree 22 | 225 Randall St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/07/2007 12:00:00 AM | 3x3 | Permit Number 51173 | 6004094.90280783 | 2097598.82668997 | 37.7398387401798 | -122.428394820361 | (37.7398387401798, -122.428394820361) | 2 | 7 | 5 | 63 | 7 | ||
| 125341 | 228345 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 5587 Diamond Heights Blvd | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 3ft | 6001625.45528 | 2097121.42182 | 37.7383878502062 | -122.436898948753 | (37.7383878502062, -122.436898948753) | 2 | 7 | 5 | 63 | 7 | |||
| 128319 | 228341 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 221 Randall St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 3ft | 6004146.11825 | 2097570.73294 | 37.7397644991391 | -122.428215737193 | (37.7397644991391, -122.428215737193) | 2 | 7 | 5 | 63 | 7 | |||
| 135924 | 228332 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 1851 Church St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 13 | Width 3ft | 6004603.41729 | 2097955.34204 | 37.7408464123237 | -122.426661971295 | (37.7408464123237, -122.426661971295) | 2 | 7 | 5 | 63 | 7 | |||
| 144520 | 43569 | Planning Code 138.1 required 2 | Ginkgo biloba :: Maidenhair Tree 22 | 601 29TH ST | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/20/2000 12:00:00 AM | 3x3 | Permit Number 43230 | 6002630.6 | 2098839.9 | 37.7431634703749 | -122.43354642925 | (37.7431634703749, -122.43354642925) | 2 | 7 | 5 | 63 | 7 | ||
| 146100 | 226293 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 515 Chenery St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 01/22/2008 12:00:00 AM | 3 | Width 2ft | Permit Number 50136 | 6003436.56035 | 2095955.228 | 37.7352885184362 | -122.430553843204 | (37.7352885184362, -122.430553843204) | 2 | 7 | 5 | 63 | 7 | |
| 146615 | 226291 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 470 Chenery St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 2ft | 6003641.69926 | 2096163.79668 | 37.7358728196591 | -122.429859474857 | (37.7358728196591, -122.429859474857) | 2 | 7 | 5 | 63 | 7 | |||
| 149018 | 228336 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 20 Whitney St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | Width 3ft | 6004252.72568 | 2098174.18641 | 37.7414274760089 | -122.427890122347 | (37.7414274760089, -122.427890122347) | 2 | 7 | 5 | 63 | 7 | |||
| 149694 | 228338 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 1768 Sanchez St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 3ft | 6003965.24462 | 2097947.62405 | 37.7407891201243 | -122.428867983974 | (37.7407891201243, -122.428867983974) | 2 | 7 | 5 | 63 | 7 | |||
| 156718 | 5736 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 1735 Dolores St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 50 | 3x3 | 6005366.76903 | 2098271.84228 | 37.74175857761 | -122.424045085308 | (37.74175857761, -122.424045085308) | 2 | 7 | 5 | 28859 | 7 | |||
| 165153 | 4880 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 72 Crags Ct | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/22/1992 12:00:00 AM | 20 | 3X3 | 6000876.35717 | 2097913.99374 | 37.7405214620835 | -122.439545759622 | (37.7405214620835, -122.439545759622) | 2 | 7 | 5 | 63 | 7 | ||
| 175978 | 228344 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 2 Digby St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 3ft | 6003262.92712 | 2097108.59296 | 37.7384455570072 | -122.4312364574 | (37.7384455570072, -122.4312364574) | 2 | 7 | 5 | 63 | 7 | |||
| 179123 | 226289 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 263 Chenery St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 2ft | 6004526.65567 | 2096812.88976 | 37.7377051577776 | -122.426846041809 | (37.7377051577776, -122.426846041809) | 2 | 7 | 5 | 63 | 7 | |||
| 181536 | 22838 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 112 Turquoise Way | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 05/01/2000 12:00:00 AM | 3 | 2X2 | 5999650.54183 | 2098943.83579 | 37.7432793203754 | -122.443858110463 | (37.7432793203754, -122.443858110463) | 2 | 7 | 5 | 63 | 7 | ||
| 192669 | 5735 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 1731 Dolores St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 04/28/2008 12:00:00 AM | 50 | 3x3 | 6005365.9005 | 2098299.94514 | 37.7418356926592 | -122.424050086446 | (37.7418356926592, -122.424050086446) | 2 | 7 | 5 | 28859 | 7 | ||
| 194438 | 225616 | Prune Opt Out 3 | Ginkgo biloba :: Maidenhair Tree 22 | 15 Conrad St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 2ft | Permit Number 787984 | 6001852.25626 | 2097023.92467 | 37.7381330336073 | -122.436107807923 | (37.7381330336073, -122.436107807923) | 2 | 7 | 5 | 63 | 7 | ||
| 2444 | 187616 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 55 Hawthorne St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | Private | 04/03/2013 12:00:00 AM | 3x3 | 6013035 | 2114021 | 37.78543223702 | -122.398635644163 | (37.78543223702, -122.398635644163) | 6 | 2 | 9 | 28855 | 6 | ||
| 2803 | 39877 | Permitted Site 7 | Ginkgo biloba :: Maidenhair Tree 22 | 301 Bryant St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 01/21/1999 12:00:00 AM | Permit Number 41173 | 6015620.67363669 | 2114221.43610992 | 37.786126305998 | -122.389703911477 | (37.786126305998, -122.389703911477) | 6 | 2 | 9 | 28855 | 6 | |||
| 3016 | 190529 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 21 Clarence Pl | 7 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 3ft | 6014722.79424 | 2111890.37318 | 37.7796759079438 | -122.392647234607 | (37.7796759079438, -122.392647234607) | 6 | 2 | 9 | 28856 | 6 | |||
| 3597 | 93954 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 1 Hawthorne St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 04/30/2010 12:00:00 AM | 2 | 3x3 | Permit Number 53397 | 6012934.64989 | 2114104.90951 | 37.7856570416874 | -122.398988719454 | (37.7856570416874, -122.398988719454) | 6 | 2 | 9 | 28855 | 6 | |
| 5372 | 256588 | Undocumented 4 | Ginkgo biloba :: Maidenhair Tree 22 | 2x Stillman St | 15 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6014165 | 2112908 | 37.7824390851954 | -122.394648183134 | (37.7824390851954, -122.394648183134) | 6 | 2 | 9 | 28856 | 6 | ||||
| 7064 | 129030 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 537 Sacramento St | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 4ft | 6012231.96171 | 2117118.21401 | 37.793891683102 | -122.401631701054 | (37.793891683102, -122.401631701054) | 4 | 1 | 10 | 28860 | 6 | |||
| 8668 | 39268 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 540 Delancey St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/14/1998 12:00:00 AM | 8 | 3x3 | Permit Number 40880 | 6015240.80145 | 2113614.13929 | 37.7844377354544 | -122.390975718675 | (37.7844377354544, -122.390975718675) | 6 | 2 | 9 | 28856 | 6 |
| 9108 | 116642 | Permitted Site 7 | Ginkgo biloba :: Maidenhair Tree 22 | 270 Brannan St | 4 | Sidewalk: Property side : Cutout | Tree | Private 2 | 1 | 3x3 | 6015144.15756 | 2112956.70855 | 37.7826272167081 | -122.391264104249 | (37.7826272167081, -122.391264104249) | 6 | 2 | 9 | 28856 | 6 | |||
| 9492 | 104107 | Permitted Site 7 | Ginkgo biloba :: Maidenhair Tree 22 | 55X Clarence Pl | 10 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2x3 | Permit Number 768392 | 6014738.33428 | 2111855.52316 | 37.7795810807004 | -122.392591035948 | (37.7795810807004, -122.392591035948) | 6 | 2 | 9 | 28856 | 6 | |||
| 11309 | 44191 | Permitted Site 7 | Ginkgo biloba :: Maidenhair Tree 22 | 100 Harrison St | 12 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/28/2000 12:00:00 AM | Permit Number 43651 | 6015694.21185643 | 2115218.20458409 | 37.7888672826794 | -122.389519124295 | (37.7888672826794, -122.389519124295) | 6 | 2 | 9 | 28855 | 6 | |||
| 11840 | 190512 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 649 Delancey St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 2ft | 6015812.43568 | 2113078.6641 | 37.7829991439482 | -122.38896064551 | (37.7829991439482, -122.38896064551) | 6 | 2 | 9 | 28856 | 6 | |||
| 12208 | 190492 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 541 Delancey St | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 6ft | 6015312.24709 | 2113599.76666 | 37.7844022356283 | -122.390727534552 | (37.7844022356283, -122.390727534552) | 6 | 2 | 9 | 28856 | 6 | |||
| 12788 | 84750 | Permitted Site 7 | Ginkgo biloba :: Maidenhair Tree 22 | 170 King St | 7 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/04/2007 12:00:00 AM | Permit No. 49304 | 6014851 | 2111791 | 37.7794101710037 | -122.392196759897 | (37.7794101710037, -122.392196759897) | 6 | 2 | 9 | 28856 | 6 | |||
| 13947 | 109612 | Undocumented 4 | Ginkgo biloba :: Maidenhair Tree 22 | 311x DAVIS ST | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6013158 | 2117662 | 37.7954364211004 | -122.398465672767 | (37.7954364211004, -122.398465672767) | 3 | 1 | 10 | 28860 | 6 | ||||
| 14813 | 190494 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 541 Delancey St | 13 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 6ft | 6015224.29962 | 2113700.39003 | 37.7846736447102 | -122.391038840285 | (37.7846736447102, -122.391038840285) | 6 | 2 | 9 | 28856 | 6 | |||
| 17276 | 72565 | Planning Code 138.1 required 2 | Ginkgo biloba :: Maidenhair Tree 22 | 270 Brannan St | 1 | Sidewalk: Property side : Cutout | Tree | Private 2 | 3 | 4x4 | Permit Number 770847 | 6015158 | 2112983 | 37.7827001752808 | -122.391218053322 | (37.7827001752808, -122.391218053322) | 6 | 2 | 9 | 28856 | 6 | ||
| 17344 | 192428 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 480 Bryant St | 1 | : | Tree | Private 2 | 1 | Width 3ft | 6014110.58587 | 2112833.82618 | 37.7822323954538 | -122.39483123728 | (37.7822323954538, -122.39483123728) | 6 | 2 | 9 | 28856 | 6 | |||
| 18366 | 39267 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 540 Delancey St | 7 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/14/1998 12:00:00 AM | 8 | 3x3 | Permit Number 40880 | 6015247.62996 | 2113604.71354 | 37.7844122333873 | -122.390951435185 | (37.7844122333873, -122.390951435185) | 6 | 2 | 9 | 28856 | 6 |
| 20218 | 190533 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 21 Clarence Pl | 11 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 3ft | 6014650.94909 | 2111960.46256 | 37.7798643671721 | -122.39290068514 | (37.7798643671721, -122.39290068514) | 6 | 2 | 9 | 28856 | 6 | |||
| 21015 | 129025 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 537 Sacramento St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 4ft | 6012112.87485 | 2117105.88276 | 37.7938511785367 | -122.402042888167 | (37.7938511785367, -122.402042888167) | 4 | 1 | 10 | 28860 | 6 | |||
| 23060 | 190465 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 253 Fremont St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 3ft | 6014265.46141 | 2115228.40431 | 37.7888159670408 | -122.394463155544 | (37.7888159670408, -122.394463155544) | 6 | 2 | 9 | 28855 | 6 | |||
| 23772 | 256577 | Undocumented 4 | Ginkgo biloba :: Maidenhair Tree 22 | 2x Stillman St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6014165 | 2112908 | 37.7824390851954 | -122.394648183134 | (37.7824390851954, -122.394648183134) | 6 | 2 | 9 | 28856 | 6 | ||||
| 25123 | 50152 | Permitted Site 7 | Ginkgo biloba :: Maidenhair Tree 22 | 215 REVISED Fremont St | 7 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 08/12/2003 12:00:00 AM | Permit Number 46870 | 6014159.85874387 | 2115328.34387959 | 37.7890845068427 | -122.3948355307 | (37.7890845068427, -122.3948355307) | 6 | 2 | 9 | 28855 | 6 | |||
| 25161 | 256581 | Undocumented 4 | Ginkgo biloba :: Maidenhair Tree 22 | 2x Stillman St | 8 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6014165 | 2112908 | 37.7824390851954 | -122.394648183134 | (37.7824390851954, -122.394648183134) | 6 | 2 | 9 | 28856 | 6 | ||||
| 27624 | 256578 | Undocumented 4 | Ginkgo biloba :: Maidenhair Tree 22 | 2x Stillman St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6014165 | 2112908 | 37.7824390851954 | -122.394648183134 | (37.7824390851954, -122.394648183134) | 6 | 2 | 9 | 28856 | 6 | ||||
| 29724 | 190468 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 253 Fremont St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 3ft | 6014180.95514 | 2115315.79758 | 37.7890512305842 | -122.394761660325 | (37.7890512305842, -122.394761660325) | 6 | 2 | 9 | 28855 | 6 | |||
| 31533 | 190515 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 649 Delancey St | 9 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 3ft | 6015672.13111 | 2113216.39507 | 37.7833695441175 | -122.389455667442 | (37.7833695441175, -122.389455667442) | 6 | 2 | 9 | 28856 | 6 | |||
| 32288 | 190505 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 648 Delancey St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 3ft | 6015586.39221 | 2113251.98255 | 37.7834625052232 | -122.389754779275 | (37.7834625052232, -122.389754779275) | 6 | 2 | 9 | 28856 | 6 | |||
| 32400 | 190513 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 649 Delancey St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 2ft | 6015752.27988 | 2113127.25011 | 37.7831292155962 | -122.389172155267 | (37.7831292155962, -122.389172155267) | 6 | 2 | 9 | 28856 | 6 | |||
| 34172 | 116641 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 270 Brannan St | 3 | Sidewalk: Property side : Cutout | Tree | Private 2 | 1 | 4x4 | 6015158 | 2112983 | 37.7827001752808 | -122.391218053322 | (37.7827001752808, -122.391218053322) | 6 | 2 | 9 | 28856 | 6 | |||
| 34180 | 190463 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 560 Mission St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 5ft | 6012913.646 | 2115176.95857 | 37.7885994678435 | -122.399136665124 | (37.7885994678435, -122.399136665124) | 12 | 2 | 9 | 28855 | 6 | |||
| 34837 | 190506 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 650 Delancey St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 2ft | 6015686.96793 | 2113146.64908 | 37.7831788599674 | -122.389399465239 | (37.7831788599674, -122.389399465239) | 6 | 2 | 9 | 28856 | 6 | |||
| 35542 | 129040 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 306 Davis St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 4ft | 6013297.17121 | 2117703.63203 | 37.7955584847826 | -122.397987035675 | (37.7955584847826, -122.397987035675) | 3 | 1 | 10 | 28860 | 6 | |||
| 37647 | 44195 | Permitted Site 7 | Ginkgo biloba :: Maidenhair Tree 22 | 100 Harrison St | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/28/2000 12:00:00 AM | Permit Number 43651 | 6015694.21185643 | 2115218.20458409 | 37.7888672826794 | -122.389519124295 | (37.7888672826794, -122.389519124295) | 6 | 2 | 9 | 28855 | 6 | |||
| 37981 | 104106 | Permitted Site 7 | Ginkgo biloba :: Maidenhair Tree 22 | 55X Clarence Pl | 9 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2x3 | Permit Number 768392 | 6014738.33428 | 2111855.52316 | 37.7795810807004 | -122.392591035948 | (37.7795810807004, -122.392591035948) | 6 | 2 | 9 | 28856 | 6 | |||
| 38441 | 104099 | Permitted Site 7 | Ginkgo biloba :: Maidenhair Tree 22 | 55X Clarence Pl | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2x3 | Permit Number 768392 | 6014738.33428 | 2111855.52316 | 37.7795810807004 | -122.392591035948 | (37.7795810807004, -122.392591035948) | 6 | 2 | 9 | 28856 | 6 | |||
| 39546 | 104103 | Permitted Site 7 | Ginkgo biloba :: Maidenhair Tree 22 | 55X Clarence Pl | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2x3 | Permit Number 768392 | 6014738.33428 | 2111855.52316 | 37.7795810807004 | -122.392591035948 | (37.7795810807004, -122.392591035948) | 6 | 2 | 9 | 28856 | 6 | |||
| 40108 | 129029 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 537 Sacramento St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 4ft | 6012209.59826 | 2117116.91261 | 37.7938868618381 | -122.401708989687 | (37.7938868618381, -122.401708989687) | 4 | 1 | 10 | 28860 | 6 | |||
| 40641 | 190503 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 538 Delancey St | 10 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 3ft | 6015171.61041 | 2113671.63758 | 37.7845917731364 | -122.39121911838 | (37.7845917731364, -122.39121911838) | 6 | 2 | 9 | 28856 | 6 | |||
| 40744 | 93957 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 1 Hawthorne St | 7 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 04/30/2010 12:00:00 AM | 2 | 3x3 | Permit Number 53397 | 6012892.58363 | 2114155.98675 | 37.7857949437324 | -122.399137844145 | (37.7857949437324, -122.399137844145) | 6 | 2 | 9 | 28855 | 6 | |
| 41338 | 109613 | Undocumented 4 | Ginkgo biloba :: Maidenhair Tree 22 | 311x DAVIS ST | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6013158 | 2117662 | 37.7954364211004 | -122.398465672767 | (37.7954364211004, -122.398465672767) | 3 | 1 | 10 | 28860 | 6 | ||||
| 42164 | 44189 | Permitted Site 7 | Ginkgo biloba :: Maidenhair Tree 22 | 100 Harrison St | 7 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/28/2000 12:00:00 AM | Permit Number 43651 | 6015694.21185643 | 2115218.20458409 | 37.7888672826794 | -122.389519124295 | (37.7888672826794, -122.389519124295) | 6 | 2 | 9 | 28855 | 6 | |||
| 44175 | 129037 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 301 Davis St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 4ft | 6013253.49225 | 2117761.73014 | 37.7957155756652 | -122.398142251463 | (37.7957155756652, -122.398142251463) | 3 | 1 | 10 | 28860 | 6 | |||
| 44799 | 84752 | Permitted Site 7 | Ginkgo biloba :: Maidenhair Tree 22 | 170 King St | 9 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/04/2007 12:00:00 AM | Permit No. 49304 | 6014851 | 2111791 | 37.7794101710037 | -122.392196759897 | (37.7794101710037, -122.392196759897) | 6 | 2 | 9 | 28856 | 6 | |||
| 45771 | 190461 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 560 Mission St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 5ft | 6012948.59757 | 2115205.37552 | 37.788679441854 | -122.399017732508 | (37.788679441854, -122.399017732508) | 12 | 2 | 9 | 28855 | 6 | |||
| 48248 | 190519 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 299 Bryant St | 27 | Sidewalk: Property side : Yard | Tree | Private 2 | 5 | Width 3ft | 6015412.94784 | 2114035.02216 | 37.785602934875 | -122.390409563945 | (37.785602934875, -122.390409563945) | 6 | 2 | 9 | 28855 | 6 | |||
| 49329 | 93956 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 1 Hawthorne St | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 04/30/2010 12:00:00 AM | 1 | 3x3 | Permit Number 53397 | 6012912.43006 | 2114137.6628 | 37.7857457364097 | -122.399067893988 | (37.7857457364097, -122.399067893988) | 6 | 2 | 9 | 28855 | 6 | |
| 49350 | 62023 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 425 Bryant St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/11/2013 12:00:00 AM | 2 | Permit Number 58528 | 6014308.72009 | 2112935.21869 | 37.7825218107646 | -122.394152876857 | (37.7825218107646, -122.394152876857) | 6 | 2 | 9 | 28856 | 6 | ||
| 51358 | 256597 | Undocumented 4 | Ginkgo biloba :: Maidenhair Tree 22 | 2x Stillman St | 24 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6014165 | 2112908 | 37.7824390851954 | -122.394648183134 | (37.7824390851954, -122.394648183134) | 6 | 2 | 9 | 28856 | 6 | ||||
| 51364 | 190475 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 30 Tehama St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 3ft | 6013873.64284 | 2114904.45941 | 37.7879047001939 | -122.395796094738 | (37.7879047001939, -122.395796094738) | 6 | 2 | 9 | 28855 | 6 |
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) );