trees
1,024 rows where qSpecies_id = 72 sorted by qAddress
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) |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
14568 | 84716 | Permitted Site 7 | Washingtonia robusta :: Mexican Fan Palm 72 | 10 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/17/2007 12:00:00 AM | Permit No. 49325 | 6001553.34694 | 2108280.88879 | 37.7690249659747 | -122.437947368595 | (37.7690249659747, -122.437947368595) | 15 | 5 | 5 | 29492 | 3 | ||||
41555 | 84715 | Permitted Site 7 | Washingtonia robusta :: Mexican Fan Palm 72 | 9 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/17/2007 12:00:00 AM | Permit No. 49325 | 6001553.34694 | 2108280.88879 | 37.7690249659747 | -122.437947368595 | (37.7690249659747, -122.437947368595) | 15 | 5 | 5 | 29492 | 3 | ||||
46619 | 84707 | Permitted Site 7 | Washingtonia robusta :: Mexican Fan Palm 72 | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/17/2007 12:00:00 AM | Permit No. 49325 | 6001553.34694 | 2108280.88879 | 37.7690249659747 | -122.437947368595 | (37.7690249659747, -122.437947368595) | 15 | 5 | 5 | 29492 | 3 | ||||
57314 | 84717 | Permitted Site 7 | Washingtonia robusta :: Mexican Fan Palm 72 | 11 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/17/2007 12:00:00 AM | Permit No. 49325 | 6001553.34694 | 2108280.88879 | 37.7690249659747 | -122.437947368595 | (37.7690249659747, -122.437947368595) | 15 | 5 | 5 | 29492 | 3 | ||||
72481 | 84712 | Permitted Site 7 | Washingtonia robusta :: Mexican Fan Palm 72 | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/17/2007 12:00:00 AM | Permit No. 49325 | 6001553.34694 | 2108280.88879 | 37.7690249659747 | -122.437947368595 | (37.7690249659747, -122.437947368595) | 15 | 5 | 5 | 29492 | 3 | ||||
104459 | 84709 | Permitted Site 7 | Washingtonia robusta :: Mexican Fan Palm 72 | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/17/2007 12:00:00 AM | Permit No. 49325 | 6001553.34694 | 2108280.88879 | 37.7690249659747 | -122.437947368595 | (37.7690249659747, -122.437947368595) | 15 | 5 | 5 | 29492 | 3 | ||||
112828 | 84714 | Permitted Site 7 | Washingtonia robusta :: Mexican Fan Palm 72 | 8 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/17/2007 12:00:00 AM | Permit No. 49325 | 6001553.34694 | 2108280.88879 | 37.7690249659747 | -122.437947368595 | (37.7690249659747, -122.437947368595) | 15 | 5 | 5 | 29492 | 3 | ||||
113084 | 84710 | Permitted Site 7 | Washingtonia robusta :: Mexican Fan Palm 72 | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/17/2007 12:00:00 AM | Permit No. 49325 | 6001553.34694 | 2108280.88879 | 37.7690249659747 | -122.437947368595 | (37.7690249659747, -122.437947368595) | 15 | 5 | 5 | 29492 | 3 | ||||
129141 | 84713 | Permitted Site 7 | Washingtonia robusta :: Mexican Fan Palm 72 | 7 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/17/2007 12:00:00 AM | Permit No. 49325 | 6001553.34694 | 2108280.88879 | 37.7690249659747 | -122.437947368595 | (37.7690249659747, -122.437947368595) | 15 | 5 | 5 | 29492 | 3 | ||||
161747 | 84708 | Permitted Site 7 | Washingtonia robusta :: Mexican Fan Palm 72 | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/17/2007 12:00:00 AM | Permit No. 49325 | 6001553.34694 | 2108280.88879 | 37.7690249659747 | -122.437947368595 | (37.7690249659747, -122.437947368595) | 15 | 5 | 5 | 29492 | 3 | ||||
161783 | 84711 | Permitted Site 7 | Washingtonia robusta :: Mexican Fan Palm 72 | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/17/2007 12:00:00 AM | Permit No. 49325 | 6001553.34694 | 2108280.88879 | 37.7690249659747 | -122.437947368595 | (37.7690249659747, -122.437947368595) | 15 | 5 | 5 | 29492 | 3 | ||||
36842 | 181277 | DPW Maintained 1 | Washingtonia robusta :: Mexican Fan Palm 72 | 0 Gonzalez Dr | 6 | Sidewalk: Curb side : Yard | Tree | Private 2 | 11 | 5988402.74919 | 2089827.84919 | 37.7176011677477 | -122.482081905481 | (37.7176011677477, -122.482081905481) | 1 | 8 | 4 | 64 | 14 | ||||
71490 | 181275 | DPW Maintained 1 | Washingtonia robusta :: Mexican Fan Palm 72 | 0 Gonzalez Dr | 4 | Sidewalk: Curb side : Yard | Tree | Private 2 | 11 | 5988424.04089 | 2089826.43294 | 37.7175985174299 | -122.482008206935 | (37.7175985174299, -122.482008206935) | 1 | 8 | 4 | 64 | 14 | ||||
92455 | 181276 | DPW Maintained 1 | Washingtonia robusta :: Mexican Fan Palm 72 | 0 Gonzalez Dr | 5 | Sidewalk: Curb side : Yard | Tree | Private 2 | 11 | 5988413.87941 | 2089827.13064 | 37.7175998421416 | -122.482043381217 | (37.7175998421416, -122.482043381217) | 1 | 8 | 4 | 64 | 14 | ||||
127322 | 202068 | DPW Maintained 1 | Washingtonia robusta :: Mexican Fan Palm 72 | 1 Hwy 101 S On Ramp | 7 | Sidewalk: Curb side : Yard | Tree | Private 2 | 12 | 6013001.93809 | 2090218.01628 | 37.7200725469917 | -122.397080431816 | (37.7200725469917, -122.397080431816) | 10 | 3 | 8 | 58 | 1 | ||||
103003 | 15076 | DPW Maintained 1 | Washingtonia robusta :: Mexican Fan Palm 72 | 1 Minerva St | 2 | Median : Cutout | Tree | DPW 1 | 6 | 11 | 5995952.59829 | 2089005.63171 | 37.7157797770894 | -122.455926258705 | (37.7157797770894, -122.455926258705) | 9 | 8 | 6 | 28861 | 24 | |||
165898 | 15067 | DPW Maintained 1 | Washingtonia robusta :: Mexican Fan Palm 72 | 1 Minerva St | 9 | Median : Cutout | Tree | DPW 1 | 3 | 11 | 5996019.74584 | 2089003.9616 | 37.7157790450506 | -122.455694046564 | (37.7157790450506, -122.455694046564) | 9 | 8 | 6 | 28861 | 24 | |||
29212 | 203185 | DPW Maintained 1 | Washingtonia robusta :: Mexican Fan Palm 72 | 10 Arkansas St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 23 | Width 4ft | 6012813.13968 | 2106962.381 | 37.7660385137928 | -122.398907634804 | (37.7660385137928, -122.398907634804) | 14 | 3 | 8 | 28856 | 20 | |||
38811 | 203184 | DPW Maintained 1 | Washingtonia robusta :: Mexican Fan Palm 72 | 10 Arkansas St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 18 | Width 4ft | 6012812.5292 | 2106977.67983 | 37.7660804869528 | -122.398910820196 | (37.7660804869528, -122.398910820196) | 14 | 3 | 8 | 28856 | 20 | |||
11007 | 260556 | DPW Maintained 1 | Washingtonia robusta :: Mexican Fan Palm 72 | 10 South Van Ness Ave | 8 | Sidewalk: Curb side : Cutout | Tree | Private 2 | Width 5ft | 6007048.80869 | 2109949.46518 | 37.7739174571708 | -122.41905723302 | (37.7739174571708, -122.41905723302) | 8 | 2 | 9 | 28853 | 19 | ||||
20345 | 243951 | DPW Maintained 1 | Washingtonia robusta :: Mexican Fan Palm 72 | 10 South Van Ness Ave | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/14/2004 12:00:00 AM | 14 | Width 5ft | Permit Number 47529 | 6007014.66541 | 2110083.11128 | 37.7742824946758 | -122.419184822535 | (37.7742824946758, -122.419184822535) | 8 | 2 | 9 | 28853 | 19 | |
24970 | 243952 | DPW Maintained 1 | Washingtonia robusta :: Mexican Fan Palm 72 | 10 South Van Ness Ave | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/14/2004 12:00:00 AM | 15 | Width 5ft | Permit Number 47529 | 6007022.68787 | 2110044.22077 | 37.7741761624211 | -122.419154312126 | (37.7741761624211, -122.419154312126) | 8 | 2 | 9 | 28853 | 19 | |
40838 | 243953 | DPW Maintained 1 | Washingtonia robusta :: Mexican Fan Palm 72 | 10 South Van Ness Ave | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/14/2004 12:00:00 AM | 14 | Width 5ft | Permit Number 47529 | 6007037.92355 | 2109985.61989 | 37.7740161163944 | -122.419097451613 | (37.7740161163944, -122.419097451613) | 8 | 2 | 9 | 28853 | 19 | |
90173 | 243954 | DPW Maintained 1 | Washingtonia robusta :: Mexican Fan Palm 72 | 10 South Van Ness Ave | 7 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/14/2004 12:00:00 AM | 15 | Width 5ft | Permit Number 47529 | 6007048.80869 | 2109949.46518 | 37.7739174571708 | -122.41905723302 | (37.7739174571708, -122.41905723302) | 8 | 2 | 9 | 28853 | 19 | |
119245 | 243948 | DPW Maintained 1 | Washingtonia robusta :: Mexican Fan Palm 72 | 10 South Van Ness Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/14/2004 12:00:00 AM | 11 | Width 5ft | Permit Number 47529 | 6006987.09759 | 2110205.04369 | 37.7746157393567 | -122.419288836304 | (37.7746157393567, -122.419288836304) | 8 | 2 | 9 | 28853 | 19 | |
119349 | 243949 | DPW Maintained 1 | Washingtonia robusta :: Mexican Fan Palm 72 | 10 South Van Ness Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/14/2004 12:00:00 AM | 12 | Width 5ft | Permit Number 47529 | 6006997.01742 | 2110160.92453 | 37.7744951573695 | -122.419251391244 | (37.7744951573695, -122.419251391244) | 8 | 2 | 9 | 28853 | 19 | |
141961 | 243950 | DPW Maintained 1 | Washingtonia robusta :: Mexican Fan Palm 72 | 10 South Van Ness Ave | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/14/2004 12:00:00 AM | 13 | Width 5ft | Permit Number 47529 | 6007004.81099 | 2110130.42285 | 37.7744118459669 | -122.419222267617 | (37.7744118459669, -122.419222267617) | 8 | 2 | 9 | 28853 | 19 | |
139922 | 102426 | DPW Maintained 1 | Washingtonia robusta :: Mexican Fan Palm 72 | 100 06th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 16 | 4x4 | 6010110.95279 | 2112392.33205 | 37.780796958746 | -122.408637087058 | (37.780796958746, -122.408637087058) | 14 | 2 | 9 | 28853 | 34 | |||
115847 | 202175 | DPW Maintained 1 | Washingtonia robusta :: Mexican Fan Palm 72 | 100 Kalmanovitz St | 2 | Sidewalk: Curb side : Yard | Tree | Private 2 | 23 | Width 2ft | 6013138.43921 | 2093044.77183 | 37.7278418441173 | -122.396806662905 | (37.7278418441173, -122.396806662905) | 10 | 3 | 8 | 58 | 1 | |||
120026 | 202174 | DPW Maintained 1 | Washingtonia robusta :: Mexican Fan Palm 72 | 100 Kalmanovitz St | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 21 | Width 2ft | 6013138.83373 | 2093054.03186 | 37.7278672922301 | -122.396805947954 | (37.7278672922301, -122.396805947954) | 10 | 3 | 8 | 58 | 1 | |||
162885 | 202177 | DPW Maintained 1 | Washingtonia robusta :: Mexican Fan Palm 72 | 100 Kalmanovitz St | 4 | Sidewalk: Curb side : Yard | Tree | Private 2 | 20 | Width 2ft | 6013132.22912 | 2093003.70662 | 37.7277287417687 | -122.396825253678 | (37.7277287417687, -122.396825253678) | 10 | 3 | 8 | 58 | 1 | |||
168493 | 202176 | DPW Maintained 1 | Washingtonia robusta :: Mexican Fan Palm 72 | 100 Kalmanovitz St | 3 | Sidewalk: Curb side : Yard | Tree | Private 2 | 21 | Width 2ft | 6013132.98284 | 2093010.28184 | 37.7277468379346 | -122.396823108819 | (37.7277468379346, -122.396823108819) | 10 | 3 | 8 | 58 | 1 | |||
102992 | 48685 | DPW Maintained 1 | Washingtonia robusta :: Mexican Fan Palm 72 | 100 Palm Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 09/12/2002 12:00:00 AM | 22 | Permit Number 45967 | 5995923.78548 | 2113769.63655 | 37.7837738786202 | -122.45781677815 | (37.7837738786202, -122.45781677815) | 11 | 6 | 1 | 54 | 31 | ||
1209 | 199473 | DPW Maintained 1 | Washingtonia robusta :: Mexican Fan Palm 72 | 1000 03rd St | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 13 | Width 5ft | 6015478.1467 | 2109531.70871 | 37.7732414619454 | -122.389869319627 | (37.7732414619454, -122.389869319627) | 14 | 3 | 9 | 310 | 20 | |||
132758 | 199471 | DPW Maintained 1 | Washingtonia robusta :: Mexican Fan Palm 72 | 1000 03rd St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 18 | Width 5ft | 6015471.47006 | 2109635.49599 | 37.7735260686063 | -122.389899666361 | (37.7735260686063, -122.389899666361) | 14 | 3 | 9 | 310 | 20 | |||
141054 | 199474 | DPW Maintained 1 | Washingtonia robusta :: Mexican Fan Palm 72 | 1000 03rd St | 8 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | Width 5ft | 6015480.23631 | 2109482.55519 | 37.7731066131226 | -122.389858657266 | (37.7731066131226, -122.389858657266) | 14 | 3 | 9 | 310 | 20 | |||
178771 | 199472 | DPW Maintained 1 | Washingtonia robusta :: Mexican Fan Palm 72 | 1000 03rd St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 14 | Width 5ft | 6015475.23167 | 2109575.21201 | 37.7733607507341 | -122.389882442542 | (37.7733607507341, -122.389882442542) | 14 | 3 | 9 | 310 | 20 | |||
906 | 25069 | DPW Maintained 1 | Washingtonia robusta :: Mexican Fan Palm 72 | 1000X Dolores St | 12 | Median : Cutout | Tree | DPW 1 | 90 | 20 | 6005114.64614 | 2102050.12648 | 37.752118640771 | -122.425185628926 | (37.752118640771, -122.425185628926) | 2 | 4 | 5 | 28862 | 22 | |||
32206 | 25065 | DPW Maintained 1 | Washingtonia robusta :: Mexican Fan Palm 72 | 1000X Dolores St | 8 | Median : Cutout | Tree | DPW 1 | 40 | 20 | 6005108.04672 | 2102186.2977 | 37.7524921625065 | -122.425218139409 | (37.7524921625065, -122.425218139409) | 2 | 4 | 5 | 28862 | 22 | |||
56852 | 25063 | DPW Maintained 1 | Washingtonia robusta :: Mexican Fan Palm 72 | 1000X Dolores St | 6 | Median : Cutout | Tree | DPW 1 | 90 | 20 | 6005101.20924 | 2102268.05958 | 37.7527162753581 | -122.425247602115 | (37.7527162753581, -122.425247602115) | 2 | 4 | 5 | 28862 | 22 | |||
58822 | 25066 | DPW Maintained 1 | Washingtonia robusta :: Mexican Fan Palm 72 | 1000X Dolores St | 9 | Median : Cutout | Tree | DPW 1 | 90 | 20 | 6005105.41948 | 2102158.55982 | 37.7524158523077 | -122.425225251269 | (37.7524158523077, -122.425225251269) | 2 | 4 | 5 | 28862 | 22 | |||
74576 | 25059 | DPW Maintained 1 | Washingtonia robusta :: Mexican Fan Palm 72 | 1000X Dolores St | 2 | Median : Cutout | Tree | DPW 1 | 40 | 20 | 6005094.91106 | 2102418.85081 | 37.7531299572042 | -122.425280111693 | (37.7531299572042, -122.425280111693) | 2 | 4 | 5 | 28862 | 22 | |||
130440 | 25060 | DPW Maintained 1 | Washingtonia robusta :: Mexican Fan Palm 72 | 1000X Dolores St | 3 | Median : Cutout | Tree | DPW 1 | 40 | 20 | 6005096.11342 | 2102391.61943 | 37.7530552540956 | -122.425274016077 | (37.7530552540956, -122.425274016077) | 2 | 4 | 5 | 28862 | 22 | |||
53769 | 28634 | DPW Maintained 1 | Washingtonia robusta :: Mexican Fan Palm 72 | 1001 Ocean Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 04/03/2003 12:00:00 AM | 25 | 5X5 | 5996752.18528 | 2091690.06821 | 37.7231964704228 | -122.453356228535 | (37.7231964704228, -122.453356228535) | 9 | 8 | 4 | 28861 | 24 | ||
117416 | 28635 | DPW Maintained 1 | Washingtonia robusta :: Mexican Fan Palm 72 | 1001 Ocean Ave | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 04/03/2003 12:00:00 AM | 21 | 5X5 | 5996764.46341 | 2091686.23626 | 37.723186652559 | -122.45331350914 | (37.723186652559, -122.45331350914) | 9 | 8 | 4 | 28861 | 24 | ||
191738 | 102441 | DPW Maintained 1 | Washingtonia robusta :: Mexican Fan Palm 72 | 1007X Mission St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 16 | 4x4 | 6010078.92624 | 2112396.71132 | 37.7808071894337 | -122.408748191999 | (37.7808071894337, -122.408748191999) | 14 | 2 | 9 | 28853 | 34 | |||
156472 | 199498 | DPW Maintained 1 | Washingtonia robusta :: Mexican Fan Palm 72 | 1008 Mission St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 20 | Width 4ft | 6010028.24719 | 2112434.38373 | 37.7809077903144 | -122.40892617503 | (37.7809077903144, -122.40892617503) | 14 | 2 | 9 | 28853 | 34 | |||
170750 | 199499 | DPW Maintained 1 | Washingtonia robusta :: Mexican Fan Palm 72 | 1008 Mission St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 21 | Width 4ft | 6009970.38295 | 2112379.67473 | 37.7807543308744 | -122.4091224952 | (37.7807543308744, -122.4091224952) | 14 | 2 | 9 | 28853 | 34 | |||
128513 | 199503 | Planning Code 138.1 required 2 | Washingtonia robusta :: Mexican Fan Palm 72 | 1009 Howard St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/25/2017 12:00:00 AM | 3 | Width 3ft | Permit Number 770993 | 6010500.98308 | 2111924.50305 | 37.7795342467397 | -122.407254787701 | (37.7795342467397, -122.407254787701) | 14 | 2 | 9 | 28853 | 34 | |
132587 | 199504 | Planning Code 138.1 required 2 | Washingtonia robusta :: Mexican Fan Palm 72 | 1009 Howard St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/25/2017 12:00:00 AM | 3 | Width 3ft | Permit Number 770993 | 6010510.13491 | 2111932.18806 | 37.7795558601644 | -122.407223669342 | (37.7795558601644, -122.407223669342) | 14 | 2 | 9 | 28853 | 34 | |
192472 | 187521 | DPW Maintained 1 | Washingtonia robusta :: Mexican Fan Palm 72 | 100x Mary Teresa St | 1 | Median : Yard | Tree | DPW 1 | 15 | Width 9ft | 6012597.41848 | 2087914.40308 | 37.7137247587658 | -122.398317184005 | (37.7137247587658, -122.398317184005) | 10 | 3 | 8 | 309 | 1 | |||
4818 | 102421 | DPW Maintained 1 | Washingtonia robusta :: Mexican Fan Palm 72 | 101 06th St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 16 | 4x4 | 6010161.06831 | 2112431.87946 | 37.7809083532874 | -122.408466502752 | (37.7809083532874, -122.408466502752) | 14 | 2 | 9 | 28853 | 34 | |||
92502 | 102420 | DPW Maintained 1 | Washingtonia robusta :: Mexican Fan Palm 72 | 101 06th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 18 | 4x4 | 6010175.35097 | 2112415.36622 | 37.7808638116673 | -122.408415926663 | (37.7808638116673, -122.408415926663) | 14 | 2 | 9 | 28853 | 34 | |||
115471 | 49090 | DPW Maintained 1 | Washingtonia robusta :: Mexican Fan Palm 72 | 101 Athens St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 23 | Permit Number 46240 | 6005000.86531 | 2092599.96167 | 37.7261641966181 | -122.424906823795 | (37.7261641966181, -122.424906823795) | 9 | 7 | 6 | 28861 | 5 | |||
52356 | 203196 | DPW Maintained 1 | Washingtonia robusta :: Mexican Fan Palm 72 | 101 Market St | 2 | Sidewalk: Curb side : Pot | Tree | Private 2 | 14 | Width 10ft | 6013792.25217 | 2116838.17263 | 37.7932096975269 | -122.396213271333 | (37.7932096975269, -122.396213271333) | 12 | 2 | 9 | 28855 | 6 | |||
151031 | 203197 | DPW Maintained 1 | Washingtonia robusta :: Mexican Fan Palm 72 | 101 Market St | 5 | Sidewalk: Curb side : Pot | Tree | Private 2 | 17 | Width 10ft | 6013808.49559 | 2116854.49545 | 37.7932554199655 | -122.396158212135 | (37.7932554199655, -122.396158212135) | 12 | 2 | 9 | 28855 | 6 | |||
189711 | 203198 | DPW Maintained 1 | Washingtonia robusta :: Mexican Fan Palm 72 | 101 Market St | 8 | Sidewalk: Curb side : Pot | Tree | Private 2 | 15 | Width 10ft | 6013828.57328 | 2116873.69458 | 37.7933092533841 | -122.396090087604 | (37.7933092533841, -122.396090087604) | 12 | 2 | 9 | 28855 | 6 | |||
27299 | 246732 | DPW Maintained 1 | Washingtonia robusta :: Mexican Fan Palm 72 | 101 Ripley St | 5 | Sidewalk: Property side : Yard | Tree | Private 2 | 20 | Width 8ft | 6008546.25114 | 2099104.34804 | 37.7442234529633 | -122.413110303201 | (37.7442234529633, -122.413110303201) | 2 | 7 | 7 | 28859 | 2 | |||
53847 | 199501 | DPW Maintained 1 | Washingtonia robusta :: Mexican Fan Palm 72 | 1012 Howard St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 16 | Width 4ft | 6010462.04247 | 2111980.93801 | 37.7796870244685 | -122.407393480232 | (37.7796870244685, -122.407393480232) | 14 | 2 | 9 | 28853 | 34 | |||
160516 | 199502 | DPW Maintained 1 | Washingtonia robusta :: Mexican Fan Palm 72 | 1012 Howard St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 18 | Width 4ft | 6010449.4105 | 2111969.43782 | 37.7796547406221 | -122.40743636892 | (37.7796547406221, -122.40743636892) | 14 | 2 | 9 | 28853 | 34 | |||
97022 | 101530 | Undocumented 4 | Washingtonia robusta :: Mexican Fan Palm 72 | 1030 Plymouth Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 14 | 4x3 | 5995974.8 | 2090771.5 | 37.7206297100162 | -122.455977107218 | (37.7206297100162, -122.455977107218) | 9 | 8 | 6 | 28861 | 24 | |||
129508 | 217448 | DPW Maintained 1 | Washingtonia robusta :: Mexican Fan Palm 72 | 1030 Plymouth Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 15 | Width 4ft | 5995947.80275 | 2090762.88147 | 37.7206044959933 | -122.456069804902 | (37.7206044959933, -122.456069804902) | 9 | 8 | 6 | 28861 | 24 | |||
165336 | 101531 | Undocumented 4 | Washingtonia robusta :: Mexican Fan Palm 72 | 1030 Plymouth Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 14 | 4x3 | 5995974.8 | 2090771.5 | 37.7206297100162 | -122.455977107218 | (37.7206297100162, -122.455977107218) | 9 | 8 | 6 | 28861 | 24 | |||
92367 | 201499 | DPW Maintained 1 | Washingtonia robusta :: Mexican Fan Palm 72 | 1038 Innes Ave | 2 | Sidewalk: Property side : Yard | Tree | Private 2 | 16 | 6018416.79538 | 2095102.47259 | 37.7337842710237 | -122.378701895477 | (37.7337842710237, -122.378701895477) | 10 | 3 | 8 | 58 | 1 | ||||
175119 | 41527 | DPW Maintained 1 | Washingtonia robusta :: Mexican Fan Palm 72 | 1038 Innes Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 04/20/2000 12:00:00 AM | 19 | Permit Number 42067 | 6018424.26197 | 2095097.67116 | 37.7337714988594 | -122.378675747684 | (37.7337714988594, -122.378675747684) | 10 | 3 | 8 | 58 | 1 | ||
134407 | 217449 | DPW Maintained 1 | Washingtonia robusta :: Mexican Fan Palm 72 | 1038 Plymouth Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 17 | Width 4ft | 5995950.20494 | 2090812.46657 | 37.7207407828315 | -122.456065084351 | (37.7207407828315, -122.456065084351) | 9 | 8 | 6 | 28861 | 24 | |||
24365 | 124344 | DPW Maintained 1 | Washingtonia robusta :: Mexican Fan Palm 72 | 105 Palm Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 22 | Width 4ft | 5995869.2461 | 2113758.79509 | 37.7837409774514 | -122.458004677882 | (37.7837409774514, -122.458004677882) | 11 | 6 | 1 | 54 | 31 | |||
32561 | 124341 | DPW Maintained 1 | Washingtonia robusta :: Mexican Fan Palm 72 | 105 Palm Ave | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 21 | Width 4ft | 5995870.37991 | 2113683.65327 | 37.7835347232349 | -122.457995315637 | (37.7835347232349, -122.457995315637) | 11 | 6 | 1 | 54 | 31 | |||
70316 | 124343 | DPW Maintained 1 | Washingtonia robusta :: Mexican Fan Palm 72 | 105 Palm Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 18 | Width 4ft | 5995870.59128 | 2113726.09219 | 37.7836512613147 | -122.457997656644 | (37.7836512613147, -122.457997656644) | 11 | 6 | 1 | 54 | 31 | |||
176948 | 124342 | DPW Maintained 1 | Washingtonia robusta :: Mexican Fan Palm 72 | 105 Palm Ave | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 21 | Width 4ft | 5995870.42219 | 2113701.84259 | 37.7835846686773 | -122.457996486135 | (37.7835846686773, -122.457996486135) | 11 | 6 | 1 | 54 | 31 | |||
30017 | 199467 | DPW Maintained 1 | Washingtonia robusta :: Mexican Fan Palm 72 | 1050 03rd St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 18 | Width 5ft | 6015455.2503 | 2109935.91808 | 37.7743500616368 | -122.389976763437 | (37.7743500616368, -122.389976763437) | 14 | 3 | 9 | 310 | 20 | |||
52778 | 199470 | DPW Maintained 1 | Washingtonia robusta :: Mexican Fan Palm 72 | 1050 03rd St | 7 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 19 | Width 5ft | 6015462.75637 | 2109791.03207 | 37.7739526530238 | -122.38994067543 | (37.7739526530238, -122.38994067543) | 14 | 3 | 9 | 310 | 20 | |||
77729 | 100555 | Undocumented 4 | Washingtonia robusta :: Mexican Fan Palm 72 | 1050X Natoma St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | 3x3 | 6007651 | 2109542 | 37.7728325469688 | -122.416945272606 | (37.7728325469688, -122.416945272606) | 8 | 2 | 9 | 28853 | 19 | |||
144530 | 100554 | Undocumented 4 | Washingtonia robusta :: Mexican Fan Palm 72 | 1050X Natoma St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | 3x3 | 6007651 | 2109542 | 37.7728325469688 | -122.416945272606 | (37.7728325469688, -122.416945272606) | 8 | 2 | 9 | 28853 | 19 | |||
172235 | 51395 | Permitted Site 7 | Washingtonia robusta :: Mexican Fan Palm 72 | 1050X Natoma St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 10/13/2004 12:00:00 AM | 12 | 3x3 | Permit Number 47722 | 6007651 | 2109542 | 37.7728325469688 | -122.416945272606 | (37.7728325469688, -122.416945272606) | 8 | 2 | 9 | 28853 | 19 |
159726 | 28631 | Permitted Site 7 | Washingtonia robusta :: Mexican Fan Palm 72 | 1051 Ocean Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 04/03/2003 12:00:00 AM | 18 | 5x5 | 5996604.51775 | 2091735.35959 | 37.7233123645372 | -122.453869952841 | (37.7233123645372, -122.453869952841) | 9 | 8 | 4 | 28861 | 24 | ||
174439 | 28632 | Permitted Site 7 | Washingtonia robusta :: Mexican Fan Palm 72 | 1051 Ocean Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 04/03/2003 12:00:00 AM | 18 | 5X5 | 5996612.56003 | 2091733.27597 | 37.7233071045053 | -122.453842001957 | (37.7233071045053, -122.453842001957) | 9 | 8 | 4 | 28861 | 24 | ||
90264 | 244861 | DPW Maintained 1 | Washingtonia robusta :: Mexican Fan Palm 72 | 106 Chattanooga St | 2 | Sidewalk: Curb side : Pot | Tree | Private 2 | 4 | Width 4ft | 6004701.8654 | 2103001.6771 | 37.7547080488647 | -122.426680842665 | (37.7547080488647, -122.426680842665) | 2 | 4 | 5 | 28862 | 22 | |||
123319 | 23052 | DPW Maintained 1 | Washingtonia robusta :: Mexican Fan Palm 72 | 1065 Valencia St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 09/16/1992 12:00:00 AM | 15 | 4X4 | 6006449.25295 | 2103416.3322 | 37.7559452321174 | -122.420667325317 | (37.7559452321174, -122.420667325317) | 2 | 4 | 7 | 28859 | 19 | ||
183868 | 96941 | DPW Maintained 1 | Washingtonia robusta :: Mexican Fan Palm 72 | 108 Palm Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 23 | 5995926.85193 | 2113670.95774 | 37.7835031091294 | -122.457799026544 | (37.7835031091294, -122.457799026544) | 11 | 6 | 1 | 54 | 31 | ||||
142763 | 23054 | DPW Maintained 1 | Washingtonia robusta :: Mexican Fan Palm 72 | 1081 Valencia St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 09/16/1992 12:00:00 AM | 12 | 4X4 | 6006403.94858 | 2103302.7071 | 37.7556306904017 | -122.420815936586 | (37.7556306904017, -122.420815936586) | 2 | 4 | 7 | 28859 | 19 | ||
168276 | 244862 | DPW Maintained 1 | Washingtonia robusta :: Mexican Fan Palm 72 | 109 Prospect Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 3ft | 6006939.89705 | 2098843.30943 | 37.7434163905501 | -122.418646232936 | (37.7434163905501, -122.418646232936) | 2 | 7 | 7 | 28859 | 2 | |||
46988 | 28581 | Permitted Site 7 | Washingtonia robusta :: Mexican Fan Palm 72 | 1100 Ocean Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 04/03/2003 12:00:00 AM | 18 | 4X4 | 5996838.9416251 | 2091728.3014296 | 37.7233064222609 | -122.453059088902 | (37.7233064222609, -122.453059088902) | 9 | 8 | 4 | 28861 | 40 | ||
57978 | 28583 | DPW Maintained 1 | Washingtonia robusta :: Mexican Fan Palm 72 | 1100 Ocean Ave | 4 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 06/29/2007 12:00:00 AM | 18 | 4X4 | 5996838.9416251 | 2091728.3014296 | 37.7233064222609 | -122.453059088902 | (37.7233064222609, -122.453059088902) | 9 | 8 | 4 | 28861 | 40 | ||
74070 | 28580 | Permitted Site 7 | Washingtonia robusta :: Mexican Fan Palm 72 | 1100 Ocean Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 04/03/2003 12:00:00 AM | 18 | 4X4 | 5996838.9416251 | 2091728.3014296 | 37.7233064222609 | -122.453059088902 | (37.7233064222609, -122.453059088902) | 9 | 8 | 4 | 28861 | 40 | ||
102587 | 28582 | DPW Maintained 1 | Washingtonia robusta :: Mexican Fan Palm 72 | 1100 Ocean Ave | 3 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 04/03/2003 12:00:00 AM | 18 | 4X4 | 5996838.9416251 | 2091728.3014296 | 37.7233064222609 | -122.453059088902 | (37.7233064222609, -122.453059088902) | 9 | 8 | 4 | 28861 | 40 | ||
128219 | 101903 | Property Tree 8 | Washingtonia robusta :: Mexican Fan Palm 72 | 1100 Ocean Ave | 4 | Front Yard : Yard | Tree | DPW 1 | Permit Number 769623 | 5996507.7 | 2092470.2 | 37.7253245106519 | -122.454257683967 | (37.7253245106519, -122.454257683967) | 9 | 7 | 4 | 28861 | 40 | ||||
144842 | 101905 | Property Tree 8 | Washingtonia robusta :: Mexican Fan Palm 72 | 1100 Ocean Ave | 6 | Front Yard : Yard | Tree | DPW 1 | Permit Number 769623 | 5996507.7 | 2092470.2 | 37.7253245106519 | -122.454257683967 | (37.7253245106519, -122.454257683967) | 9 | 7 | 4 | 28861 | 40 | ||||
191552 | 101904 | Property Tree 8 | Washingtonia robusta :: Mexican Fan Palm 72 | 1100 Ocean Ave | 5 | Front Yard : Yard | Tree | DPW 1 | Permit Number 769623 | 5996507.7 | 2092470.2 | 37.7253245106519 | -122.454257683967 | (37.7253245106519, -122.454257683967) | 9 | 7 | 4 | 28861 | 40 | ||||
22360 | 28610 | DPW Maintained 1 | Washingtonia robusta :: Mexican Fan Palm 72 | 1107 Ocean Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 06/29/2007 12:00:00 AM | 18 | 5X5 | 5996451.82773 | 2091748.49661 | 37.7233396801105 | -122.454398718898 | (37.7233396801105, -122.454398718898) | 9 | 8 | 4 | 28861 | 24 | ||
139501 | 217428 | DPW Maintained 1 | Washingtonia robusta :: Mexican Fan Palm 72 | 1113 Kirkham St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 23 | Width 3ft | 5991492.83801 | 2105186.64815 | 37.7599517618807 | -122.472520091336 | (37.7599517618807, -122.472520091336) | 1 | 8 | 4 | 56 | 12 | |||
148209 | 217429 | DPW Maintained 1 | Washingtonia robusta :: Mexican Fan Palm 72 | 1113 Kirkham St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 25 | Width 3ft | 5991520.38705 | 2105187.01956 | 37.7599543762085 | -122.472424840551 | (37.7599543762085, -122.472424840551) | 1 | 8 | 4 | 56 | 12 | |||
172189 | 217430 | DPW Maintained 1 | Washingtonia robusta :: Mexican Fan Palm 72 | 1113 Kirkham St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 18 | Width 3ft | 5991534.38297 | 2105188.62915 | 37.7599596057689 | -122.47237655325 | (37.7599596057689, -122.47237655325) | 1 | 8 | 4 | 56 | 12 | |||
51955 | 181268 | DPW Maintained 1 | Washingtonia robusta :: Mexican Fan Palm 72 | 1116 Girard St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 17 | Width 3ft | 6011841.7145 | 2089718.86782 | 37.7186373306372 | -122.401055901109 | (37.7186373306372, -122.401055901109) | 10 | 7 | 8 | 309 | 39 | |||
168581 | 28609 | Permitted Site 7 | Washingtonia robusta :: Mexican Fan Palm 72 | 1117 Ocean Ave | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 04/03/2003 12:00:00 AM | 18 | 5X5 | 5996444.46775 | 2091779.60617 | 37.7234246775002 | -122.454426406995 | (37.7234246775002, -122.454426406995) | 9 | 8 | 4 | 28861 | 24 | ||
6999 | 137503 | DPW Maintained 1 | Washingtonia robusta :: Mexican Fan Palm 72 | 1142 Filbert St | 2 | Sidewalk: Curb side : Yard | Tree | Private 2 | 28 | Width 3ft | 6007446.54333 | 2119552.35251 | 37.8003070257165 | -122.418362418606 | (37.8003070257165, -122.418362418606) | 5 | 1 | 1 | 28858 | 32 | |||
184479 | 28584 | DPW Maintained 1 | Washingtonia robusta :: Mexican Fan Palm 72 | 1150 Ocean Ave | 10 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 04/03/2003 12:00:00 AM | 18 | 3X3 | 5996037.5543 | 2091961.17869 | 37.7238998872933 | -122.455846143025 | (37.7238998872933, -122.455846143025) | 9 | 8 | 4 | 28861 | 40 | ||
167513 | 105068 | Undocumented 4 | Washingtonia robusta :: Mexican Fan Palm 72 | 117 PROSPECT AVE | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6006924.9 | 2098775.6 | 37.7432296312701 | -122.41869328836 | (37.7432296312701, -122.41869328836) | 2 | 7 | 7 | 28859 | 2 | ||||
29738 | 244863 | DPW Maintained 1 | Washingtonia robusta :: Mexican Fan Palm 72 | 117 Prospect Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 17 | Width 3ft | 6006906.41702 | 2098789.62543 | 37.7432671013094 | -122.418758192246 | (37.7432671013094, -122.418758192246) | 2 | 7 | 7 | 28859 | 2 | |||
26706 | 16408 | DPW Maintained 1 | Washingtonia robusta :: Mexican Fan Palm 72 | 1186X Munich St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 42 | TR | 6001104.60764 | 2087178.31507 | 37.7110567247495 | -122.43798776335 | (37.7110567247495, -122.43798776335) | 9 | 7 | 6 | 28861 | 5 |
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) );