trees
67 rows where SiteOrder = 2 and qSpecies_id = 91 sorted by qCareAssistant
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) |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
888 | 246022 | DPW Maintained 1 | Schinus molle :: California Pepper 91 | 625 Ashbury St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 0ft | 5998964.2184 | 2108548.4801 | 37.769612128289 | -122.446922226392 | (37.769612128289, -122.446922226392) | 15 | 5 | 11 | 29492 | 9 | |||
3391 | 122720 | DPW Maintained 1 | Schinus molle :: California Pepper 91 | 1023 Broadway | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6008692.81337 | 2118287.13673 | 37.796903132994 | -122.413960264957 | (37.796903132994, -122.413960264957) | 5 | 1 | 10 | 308 | 21 | ||||
7042 | 264648 | DPW Maintained 1 | Schinus molle :: California Pepper 91 | 2400 Keith St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 3x3 | 6014365 | 2092317 | 37.7259117231873 | -122.392515496721 | (37.7259117231873, -122.392515496721) | 10 | 3 | 8 | 58 | 1 | ||||
9411 | 33144 | Permitted Site 7 | Schinus molle :: California Pepper 91 | 4238 21st St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/05/1996 12:00:00 AM | Permit Number 37370 | 6001375.34520428 | 2103384.04824408 | 37.7555693169237 | -122.438212219782 | (37.7555693169237, -122.438212219782) | 2 | 4 | 5 | 28862 | 3 | |||
13603 | 239638 | DPW Maintained 1 | Schinus molle :: California Pepper 91 | 3689 21st St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 3ft | 6003857.31467 | 2103604.80906 | 37.7563163226577 | -122.429644541356 | (37.7563163226577, -122.429644541356) | 2 | 4 | 5 | 28862 | 22 | |||
18353 | 97155 | Section 806 (d) 5 | Schinus molle :: California Pepper 91 | 1079 Le Conte Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 08/25/2011 12:00:00 AM | 3 | Permit Number 768080 | 6012703.24235 | 2089857.95173 | 37.7190672497343 | -122.398087681509 | (37.7190672497343, -122.398087681509) | 10 | 3 | 8 | 58 | 1 | ||
18879 | 19971 | DPW Maintained 1 | Schinus molle :: California Pepper 91 | 100 STAIRWAY44 | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 15 | |||||||||||||
20090 | 104219 | Permitted Site 7 | Schinus molle :: California Pepper 91 | 642-652 Castro St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6002365 | 2104465 | 37.7585935873912 | -122.434866988999 | (37.7585935873912, -122.434866988999) | 2 | 4 | 5 | 28862 | 3 | ||||
21141 | 51696 | Permitted Site 7 | Schinus molle :: California Pepper 91 | 4384@ TEMPLE 17th St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 04/29/2005 12:00:00 AM | Permit Number 47972 | 6000123.14739521 | 2105790.85513139 | 37.7621065191401 | -122.442715506918 | (37.7621065191401, -122.442715506918) | 15 | 5 | 5 | 28862 | 3 | |||
23648 | 239611 | DPW Maintained 1 | Schinus molle :: California Pepper 91 | 230 Esmeralda Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 13 | Width 5ft | 6007188.60592 | 2098802.03139 | 37.7433170496408 | -122.417783333431 | (37.7433170496408, -122.417783333431) | 2 | 7 | 7 | 28859 | 2 | |||
25942 | 197503 | DPW Maintained 1 | Schinus molle :: California Pepper 91 | 1799 25th St | 2 | Sidewalk: Property side : Yard | Tree | Private 2 | 9 | Width 8ft | 6013488.947 | 2101929.32561 | 37.7522564753565 | -122.396217358746 | (37.7522564753565, -122.396217358746) | 10 | 3 | 8 | 28856 | 1 | |||
26202 | 32764 | Permitted Site 7 | Schinus molle :: California Pepper 91 | 274 02nd Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/29/1996 12:00:00 AM | Permit Number 37139 | 5995268.23997636 | 2113729.87048347 | 37.7836270090334 | -122.460081822154 | (37.7836270090334, -122.460081822154) | 11 | 6 | 2 | 54 | 11 | |||
29837 | 214153 | DPW Maintained 1 | Schinus molle :: California Pepper 91 | 391 Santa Ana Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 16 | Width 3ft | 5992476.67943 | 2094212.83068 | 37.7298773579434 | -122.46831913414 | (37.7298773579434, -122.46831913414) | 9 | 8 | 4 | 59 | 40 | |||
32012 | 35755 | DPW Maintained 1 | Schinus molle :: California Pepper 91 | 6838 Geary Blvd | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 04/20/1998 12:00:00 AM | 7 | Permit Number 39022 | 5985827.97682 | 2112563.40957 | 37.7798767531698 | -122.49265512383 | (37.7798767531698, -122.49265512383) | 11 | 6 | 2 | 55 | 26 | ||
33437 | 239641 | DPW Maintained 1 | Schinus molle :: California Pepper 91 | 3637 21st St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 14 | Width 3ft | 6004113.74882 | 2103625.61972 | 37.7563879806327 | -122.428759186701 | (37.7563879806327, -122.428759186701) | 2 | 4 | 5 | 28862 | 22 | |||
33717 | 99818 | Undocumented 4 | Schinus molle :: California Pepper 91 | 1134 Castro St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6x6 | 6002486 | 2102282 | 37.7526064609065 | -122.434292449268 | (37.7526064609065, -122.434292449268) | 2 | 4 | 5 | 28862 | 22 | ||||
34897 | 136370 | DPW Maintained 1 | Schinus molle :: California Pepper 91 | 2945 Scott St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 4ft | 6000983.74683 | 2118556.26599 | 37.7972061120278 | -122.440654703763 | (37.7972061120278, -122.440654703763) | 13 | 9 | 1 | 57 | 17 | |||
35161 | 239594 | DPW Maintained 1 | Schinus molle :: California Pepper 91 | 636 Douglass St | 2 | Sidewalk: Curb side : Yard | Tree | Private 2 | 10 | Width 4ft | 6001191.4238 | 2102669.11785 | 37.7535958285084 | -122.43879704705 | (37.7535958285084, -122.43879704705) | 2 | 4 | 5 | 28862 | 22 | |||
35370 | 35616 | Permitted Site 7 | Schinus molle :: California Pepper 91 | 42 Walter St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 03/30/1998 12:00:00 AM | Permit Number 38971 | 6003128.23907612 | 2108063.84146095 | 37.7685184402848 | -122.432484413704 | (37.7685184402848, -122.432484413704) | 15 | 5 | 5 | 28862 | 3 | |||
36697 | 33682 | DPW Maintained 1 | Schinus molle :: California Pepper 91 | 417 Ivy St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/03/1996 12:00:00 AM | 8 | Permit Number 37761 | 6005332.3776 | 2111131.0936 | 37.7770651154691 | -122.425078750067 | (37.7770651154691, -122.425078750067) | 7 | 9 | 11 | 28852 | 10 | ||
40288 | 239571 | DPW Maintained 1 | Schinus molle :: California Pepper 91 | 254 Day St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 33 | Width 3ft | 6004273.21361 | 2098704.8278 | 37.742885654747 | -122.427857083959 | (37.742885654747, -122.427857083959) | 2 | 7 | 5 | 63 | 22 | |||
43385 | 136376 | DPW Maintained 1 | Schinus molle :: California Pepper 91 | 2880 Vallejo St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 25 | Width 4ft | 5999781.6675 | 2117438.62155 | 37.7940688297731 | -122.444733809114 | (37.7940688297731, -122.444733809114) | 13 | 9 | 1 | 57 | 27 | |||
44107 | 111384 | DPW Maintained 1 | Schinus molle :: California Pepper 91 | 340 Brannan St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 21 | 3x5 | 6014593.21542 | 2112428.75748 | 37.7811469919725 | -122.393133189548 | (37.7811469919725, -122.393133189548) | 6 | 2 | 9 | 28856 | 6 | |||
44499 | 197504 | DPW Maintained 1 | Schinus molle :: California Pepper 91 | 1798 Revere Ave | 2 | Sidewalk: Curb side : Yard | Tree | Private 2 | 12 | 6014086.53204 | 2095170.83461 | 37.733732305508 | -122.393677804596 | (37.733732305508, -122.393677804596) | 10 | 3 | 8 | 58 | 1 | ||||
48977 | 173723 | DPW Maintained 1 | Schinus molle :: California Pepper 91 | 1799x 25th St | 2 | Sidewalk: Property side : Cutout | Tree | Private 2 | 6013424 | 2101939 | 37.7522794251173 | -122.396442635345 | (37.7522794251173, -122.396442635345) | 10 | 3 | 8 | 28856 | 1 | |||||
51033 | 12258 | DPW Maintained 1 | Schinus molle :: California Pepper 91 | 601 Laguna St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 3X3 | 6004950.99275 | 2110977.71573 | 37.7766224258639 | -122.426387156922 | (37.7766224258639, -122.426387156922) | 7 | 9 | 11 | 28852 | 10 | |||
52252 | 247663 | DPW Maintained 1 | Schinus molle :: California Pepper 91 | 108 Divisadero St | 2 | : | Tree | Private 2 | 11 | Width 3ft | 6001959.36889 | 2108361.77304 | 37.7692701349494 | -122.436548756347 | (37.7692701349494, -122.436548756347) | 15 | 5 | 5 | 29492 | 9 | |||
53347 | 239658 | DPW Maintained 1 | Schinus molle :: California Pepper 91 | 80 Uranus Ter | 2 | Sidewalk: Property side : Yard | Tree | Private 2 | 18 | Width 3ft | 5999334.19979 | 2105297.48672 | 37.7607068452574 | -122.445408687374 | (37.7607068452574, -122.445408687374) | 15 | 5 | 5 | 28862 | 3 | |||
61318 | 136374 | DPW Maintained 1 | Schinus molle :: California Pepper 91 | 2858 Vallejo St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 4ft | 5999876.11536 | 2117451.30478 | 37.7941090438496 | -122.444407922699 | (37.7941090438496, -122.444407922699) | 13 | 9 | 1 | 57 | 27 | |||
62891 | 214155 | DPW Maintained 1 | Schinus molle :: California Pepper 91 | 495 Pacheco St | 2 | Sidewalk: Curb side : Yard | Tree | Private 2 | 5 | Width 6ft | 5993543.01566 | 2101855.50119 | 37.7509237457529 | -122.46518761832 | (37.7509237457529, -122.46518761832) | 1 | 8 | 4 | 29491 | 40 | |||
63400 | 242003 | DPW Maintained 1 | Schinus molle :: California Pepper 91 | 920 Shotwell St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/08/2017 12:00:00 AM | 3 | 3x3 | Permit Number 779528 | 6007974.01021 | 2102435.99237 | 37.7533392591026 | -122.415324800104 | (37.7533392591026, -122.415324800104) | 2 | 4 | 7 | 28859 | 19 | |
63489 | 113030 | Undocumented 4 | Schinus molle :: California Pepper 91 | 200x ESMERALDA AVE | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | 9x9 | 6007093 | 2098828 | 37.7433829729046 | -122.41811575542 | (37.7433829729046, -122.41811575542) | 2 | 7 | 7 | 28859 | 2 | |||
63916 | 239643 | DPW Maintained 1 | Schinus molle :: California Pepper 91 | 37 Ford St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 15 | Width 3ft | 6003364.63638 | 2105630.60252 | 37.7618507577208 | -122.431493007021 | (37.7618507577208, -122.431493007021) | 15 | 4 | 5 | 28862 | 3 | |||
78357 | 197485 | DPW Maintained 1 | Schinus molle :: California Pepper 91 | 15 Lafayette St | 2 | : | Tree | Private 2 | 13 | Width 3ft | 6007471.02195 | 2109700.81958 | 37.773258502312 | -122.417579097413 | (37.773258502312, -122.417579097413) | 8 | 2 | 9 | 28853 | 19 | |||
81055 | 239662 | DPW Maintained 1 | Schinus molle :: California Pepper 91 | 1128 Castro St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 13 | Width 4ft | 6002485.47315 | 2102221.41113 | 37.7524400683713 | -122.434289939928 | (37.7524400683713, -122.434289939928) | 2 | 4 | 5 | 28862 | 22 | |||
81419 | 136381 | DPW Maintained 1 | Schinus molle :: California Pepper 91 | 1023 Broadway | 2 | Sidewalk: Curb side : Pot | Tree | Private 2 | 15 | Width 3ft | 6008695.6423 | 2118278.07408 | 37.7968784080765 | -122.413949834731 | (37.7968784080765, -122.413949834731) | 5 | 1 | 10 | 308 | 21 | |||
82256 | 197486 | DPW Maintained 1 | Schinus molle :: California Pepper 91 | 1112 Tennessee St | 2 | Sidewalk: Curb side : Pot | Tree | Private 2 | 19 | Width 6ft | 6015516.35006 | 2103817.53146 | 37.7575536899561 | -122.389338063096 | (37.7575536899561, -122.389338063096) | 10 | 3 | 8 | 28856 | 29 | |||
83952 | 109126 | Private 9 | Schinus molle :: California Pepper 91 | 890x CASTRO ST | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | 3x3 | 6002411 | 2103002 | 37.7545791519678 | -122.434603290485 | (37.7545791519678, -122.434603290485) | 2 | 4 | 5 | 28862 | 22 | |||
87375 | 187555 | DPW Maintained 1 | Schinus molle :: California Pepper 91 | 3960 Somerset St | 2 | Side Yard : Yard | Tree | Private 2 | 5 | 6011363.78669 | 2088352.31881 | 37.714858391064 | -122.402611866762 | (37.714858391064, -122.402611866762) | 10 | 7 | 8 | 309 | 39 | ||||
90218 | 197483 | DPW Maintained 1 | Schinus molle :: California Pepper 91 | 99 Lafayette St | 2 | : | Tree | Private 2 | 7 | Width 3ft | 6007475.11808 | 2109661.30518 | 37.7731502356402 | -122.417562127216 | (37.7731502356402, -122.417562127216) | 8 | 2 | 9 | 28853 | 19 | |||
95494 | 136372 | DPW Maintained 1 | Schinus molle :: California Pepper 91 | 2005 Lyon St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 4ft | 5999418.04323 | 2115732.63691 | 37.7893638888782 | -122.445869229291 | (37.7893638888782, -122.445869229291) | 13 | 6 | 1 | 29490 | 31 | |||
95933 | 217745 | DPW Maintained 1 | Schinus molle :: California Pepper 91 | 641 Frederick St | 2 | : | Tree | Private 2 | 5 | Width 3ft | 5996420.96236 | 2107271.42438 | 37.7659600380538 | -122.45562688879 | (37.7659600380538, -122.45562688879) | 15 | 5 | 11 | 29492 | 12 | |||
98903 | 239612 | DPW Maintained 1 | Schinus molle :: California Pepper 91 | 220 Esmeralda Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 16 | Width 4ft | 6007237.85888 | 2098768.99356 | 37.7432291067493 | -122.417610687906 | (37.7432291067493, -122.417610687906) | 2 | 7 | 7 | 28859 | 2 | |||
99960 | 239625 | DPW Maintained 1 | Schinus molle :: California Pepper 91 | 811 Castro St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 14 | Width 3ft | 6002472.06672 | 2103464.35538 | 37.7558521357906 | -122.434425161094 | (37.7558521357906, -122.434425161094) | 2 | 4 | 5 | 28862 | 22 | |||
100527 | 187546 | DPW Maintained 1 | Schinus molle :: California Pepper 91 | 1399 Somerset St | 2 | Side Yard : Yard | Tree | Private 2 | 24 | 6011366.67431 | 2088362.22575 | 37.7148857547405 | -122.402602582141 | (37.7148857547405, -122.402602582141) | 10 | 7 | 8 | 309 | 39 | ||||
104997 | 245452 | DPW Maintained 1 | Schinus molle :: California Pepper 91 | 2700 16th St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 0ft | 6008618.5823 | 2106848.9813 | 37.7654925250272 | -122.413407794567 | (37.7654925250272, -122.413407794567) | 8 | 4 | 7 | 28853 | 19 | |||
108016 | 239647 | DPW Maintained 1 | Schinus molle :: California Pepper 91 | 211 Cumberland St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 3ft | 6004225.35965 | 2104505.85925 | 37.7588112263749 | -122.428435935269 | (37.7588112263749, -122.428435935269) | 2 | 4 | 5 | 28862 | 3 | |||
112280 | 239644 | DPW Maintained 1 | Schinus molle :: California Pepper 91 | 4 Ford St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 3ft | 6003494.59862 | 2105679.78343 | 37.7619931617634 | -122.431047029612 | (37.7619931617634, -122.431047029612) | 15 | 4 | 5 | 28862 | 3 | |||
128342 | 239654 | DPW Maintained 1 | Schinus molle :: California Pepper 91 | 3512 21st St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 20 | Width 3ft | 6004884 | 2103735 | 37.7567318772846 | -122.42610317358 | (37.7567318772846, -122.42610317358) | 2 | 4 | 5 | 28862 | 3 | |||
129788 | 239614 | DPW Maintained 1 | Schinus molle :: California Pepper 91 | 249 Precita Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 14 | Width 3ft | 6007957.74109 | 2100292.59771 | 37.7474530659031 | -122.41522934697 | (37.7474530659031, -122.41522934697) | 2 | 7 | 7 | 28859 | 2 | |||
135825 | 239592 | DPW Maintained 1 | Schinus molle :: California Pepper 91 | 1643 Diamond St | 2 | Sidewalk: Property side : Yard | Tree | Private 2 | 9 | Width 6ft | 6002072.60016 | 2099184.21674 | 37.7440772079026 | -122.435500467872 | (37.7440772079026, -122.435500467872) | 2 | 7 | 5 | 63 | 22 | |||
136874 | 136371 | DPW Maintained 1 | Schinus molle :: California Pepper 91 | 3518 Webster St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | Width 3ft | 6002669.28578 | 2120724.92735 | 37.8032565295236 | -122.434977502225 | (37.8032565295236, -122.434977502225) | 13 | 9 | 1 | 57 | 17 | |||
136995 | 46069 | Permitted Site 7 | Schinus molle :: California Pepper 91 | 3746 21st St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/12/2001 12:00:00 AM | Permit Number 44454 | 6003440.19743527 | 2103634.04731282 | 37.7563729765603 | -122.431089163341 | (37.7563729765603, -122.431089163341) | 2 | 4 | 5 | 28862 | 3 | |||
139465 | 247659 | DPW Maintained 1 | Schinus molle :: California Pepper 91 | 129 Divisadero St | 2 | : | Tree | Private 2 | 8 | Width 3ft | 6001899.88473 | 2108418.65056 | 37.7694229261437 | -122.436758580761 | (37.7694229261437, -122.436758580761) | 15 | 5 | 5 | 29492 | 9 | |||
141927 | 197501 | DPW Maintained 1 | Schinus molle :: California Pepper 91 | 1101 Connecticut St | 2 | Sidewalk: Property side : Yard | Tree | Private 2 | 7 | Width 8ft | 6013434.27998 | 2101904.95506 | 37.752186517095 | -122.396404699215 | (37.752186517095, -122.396404699215) | 10 | 3 | 8 | 28856 | 1 | |||
147452 | 183550 | DPW Maintained 1 | Schinus molle :: California Pepper 91 | 2593 23rd Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 13 | Width 0ft | 5989227.3726 | 2097702.4617 | 37.7392707770079 | -122.479807490437 | (37.7392707770079, -122.479807490437) | 1 | 8 | 3 | 29491 | 35 | |||
148800 | 84811 | Permitted Site 7 | Schinus molle :: California Pepper 91 | 654 Shrader St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 02/20/2007 12:00:00 AM | Permit No. 49280 | 5997579.9 | 2108309.3 | 37.7688762175244 | -122.451693255762 | (37.7688762175244, -122.451693255762) | 15 | 5 | 11 | 29492 | 9 | |||
153086 | 136379 | DPW Maintained 1 | Schinus molle :: California Pepper 91 | 1 Nob Hill Pl | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | Width 1ft | 6009499.81555 | 2116296.95751 | 37.7914838769232 | -122.411027191854 | (37.7914838769232, -122.411027191854) | 5 | 1 | 10 | 28857 | 21 | |||
158691 | 112685 | Undocumented 4 | Schinus molle :: California Pepper 91 | 86 STANTON ST | 2 | Front Yard : Yard | Tree | Private 2 | 3x3 | 6000281 | 2103909 | 37.7569484049338 | -122.442034474193 | (37.7569484049338, -122.442034474193) | 2 | 4 | 5 | 28862 | 38 | ||||
166727 | 239603 | DPW Maintained 1 | Schinus molle :: California Pepper 91 | 890 Castro St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 13 | Width 4ft | 6002439.95737 | 2103017.51215 | 37.7546233884599 | -122.434504257392 | (37.7546233884599, -122.434504257392) | 2 | 4 | 5 | 28862 | 22 | |||
168249 | 239583 | DPW Maintained 1 | Schinus molle :: California Pepper 91 | 857 Clayton St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 13 | Width 3ft | 5998663.26171 | 2107205.3997 | 37.7659071714014 | -122.447866512943 | (37.7659071714014, -122.447866512943) | 15 | 5 | 11 | 29492 | 9 | |||
182586 | 138852 | DPW Maintained 1 | Schinus molle :: California Pepper 91 | 604 Hayes St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 17 | Width 0ft | 6004921.1795 | 2110937.9117 | 37.776511448416 | -122.426487454824 | (37.776511448416, -122.426487454824) | 7 | 9 | 11 | 28852 | 10 | |||
189202 | 239636 | DPW Maintained 1 | Schinus molle :: California Pepper 91 | 3691 21st St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 3ft | 6003794.28038 | 2103601.33494 | 37.7563032141343 | -122.429862287926 | (37.7563032141343, -122.429862287926) | 2 | 4 | 5 | 28862 | 22 | |||
189330 | 117358 | DPW Maintained 1 | Schinus molle :: California Pepper 91 | 602 Hayes St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 18 | 3x3 | 6004920.03397 | 2110936.25791 | 37.7765068427555 | -122.426491299758 | (37.7765068427555, -122.426491299758) | 7 | 9 | 11 | 28852 | 10 | |||
194508 | 203796 | DPW Maintained 1 | Schinus molle :: California Pepper 91 | 460 Pacheco St | 2 | Sidewalk: Curb side : Yard | Tree | Private 2 | 1 | Width 6ft | 5993728.30174 | 2101878.83793 | 37.7509985054805 | -122.464548580761 | (37.7509985054805, -122.464548580761) | 1 | 8 | 4 | 29491 | 12 | |||
59175 | 46762 | Permitted Site 7 | Schinus molle :: California Pepper 91 | 220 Esmeralda Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 04/24/2002 12:00:00 AM | 14 | 6x5 | Permit Number 44860 | 6007156.68652731 | 2098808.76351871 | 37.7433337382313 | -122.417894179823 | (37.7433337382313, -122.417894179823) | 2 | 7 | 7 | 28859 | 2 |
59453 | 49620 | DPW Maintained 1 | Schinus molle :: California Pepper 91 | 180 11th St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 05/30/2008 12:00:00 AM | 5 | 3x3 | Permit Number 768701 | 6007925.38179 | 2109711.75094 | 37.7733140732115 | -122.416008175135 | (37.7733140732115, -122.416008175135) | 8 | 2 | 9 | 28853 | 19 |
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) );