trees
420 rows where qSpecies_id = 116 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) |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 59259 | 215414 | DPW Maintained 1 | Trachycarpus fortunei :: Windmill Palm 116 | 423 Flood Ave | 3 | Sidewalk: Property side : Yard | Tree | Private 2 | 13 | Width 6ft | 5997954.5929 | 2094069.33464 | 37.7297982247933 | -122.449371101191 | (37.7297982247933, -122.449371101191) | 9 | 7 | 4 | 28861 | 40 | |||
| 60373 | 215429 | DPW Maintained 1 | Trachycarpus fortunei :: Windmill Palm 116 | 20 Lakewood Ave | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 3ft | 5993645.02193 | 2093008.92736 | 37.726639146565 | -122.464192703738 | (37.726639146565, -122.464192703738) | 9 | 8 | 4 | 59 | 40 | |||
| 60671 | 103568 | Undocumented 4 | Trachycarpus fortunei :: Windmill Palm 116 | 223 Parnassus Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | 3x3 | 5997125.5 | 2106655.6 | 37.7643095465843 | -122.453145590268 | (37.7643095465843, -122.453145590268) | 15 | 5 | 11 | 29492 | 12 | |||
| 61025 | 253495 | Planning Code 138.1 required 2 | Trachycarpus fortunei :: Windmill Palm 116 | 1x Gordon St | 13 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 09/12/2017 12:00:00 AM | 3 | 3x3 | Permit Number 772214 | 6009763 | 2109812 | 37.7736924789578 | -122.409658650953 | (37.7736924789578, -122.409658650953) | 8 | 2 | 9 | 28853 | 34 | |
| 61533 | 106452 | Permitted Site 7 | Trachycarpus fortunei :: Windmill Palm 116 | 56 Lucy St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 04/28/2014 12:00:00 AM | 3 | Permit Number 772906 | 6014092.7 | 2093830.3 | 37.7300518134974 | -122.393562691323 | (37.7300518134974, -122.393562691323) | 10 | 3 | 8 | 58 | 1 | ||
| 62710 | 198002 | DPW Maintained 1 | Trachycarpus fortunei :: Windmill Palm 116 | 860x Jamestown Ave | 13 | Median : Cutout | Tree | DPW 1 | 6 | Width 5ft | 6014610.54339 | 2089241.61494 | 37.717480958049 | -122.39145176041 | (37.717480958049, -122.39145176041) | 10 | 3 | 8 | 58 | 1 | |||
| 62921 | 16273 | DPW Maintained 1 | Trachycarpus fortunei :: Windmill Palm 116 | 692X Monterey Blvd | 2 | Median : Cutout | Tree | DPW 1 | 02/02/2003 12:00:00 AM | 12 | 3X3 | 5997509.7184819 | 2094751.8939266 | 37.7316469123248 | -122.450958273614 | (37.7316469123248, -122.450958273614) | 9 | 7 | 4 | 59 | 40 | ||
| 64512 | 100205 | Undocumented 4 | Trachycarpus fortunei :: Windmill Palm 116 | 4085 20th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 09/27/2012 12:00:00 AM | 12 | 3x4 | Permit Number 769140 | 6003091 | 2104064 | 37.7575337303282 | -122.432327515179 | (37.7575337303282, -122.432327515179) | 2 | 4 | 5 | 28862 | 3 | |
| 65614 | 197983 | DPW Maintained 1 | Trachycarpus fortunei :: Windmill Palm 116 | 1809 19th St | 5 | Sidewalk: Property side : Yard | Tree | Private 2 | 8 | Width 6ft | 6012297.3164 | 2105130.82765 | 37.7609807202963 | -122.400563103211 | (37.7609807202963, -122.400563103211) | 10 | 3 | 8 | 28856 | 29 | |||
| 65860 | 215426 | DPW Maintained 1 | Trachycarpus fortunei :: Windmill Palm 116 | 15 Fairfield Way | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 3ft | 5993822.27885 | 2092914.39696 | 37.7263898041365 | -122.463573079846 | (37.7263898041365, -122.463573079846) | 9 | 8 | 4 | 59 | 40 | |||
| 66245 | 241184 | DPW Maintained 1 | Trachycarpus fortunei :: Windmill Palm 116 | 1720 Dolores St | 8 | Sidewalk: Property side : Yard | Tree | Private 2 | 3 | Width 3ft | 6005265.18206 | 2098303.13157 | 37.7418387548635 | -122.424398564767 | (37.7418387548635, -122.424398564767) | 2 | 7 | 5 | 63 | 7 | |||
| 67469 | 197991 | DPW Maintained 1 | Trachycarpus fortunei :: Windmill Palm 116 | 3419 Jennings St | 2 | Sidewalk: Curb side : Yard | Tree | Private 2 | 13 | 6013294.96544 | 2089742.68292 | 37.7187836844998 | -122.396034235213 | (37.7187836844998, -122.396034235213) | 10 | 3 | 8 | 58 | 1 | ||||
| 68174 | 179967 | DPW Maintained 1 | Trachycarpus fortunei :: Windmill Palm 116 | 716 Peru Ave | 8 | Sidewalk: Property side : Yard | Tree | Private 2 | 9 | Width 2ft | 6005275.29843 | 2092450.03888 | 37.7257680389529 | -122.423947466603 | (37.7257680389529, -122.423947466603) | 9 | 7 | 6 | 309 | 5 | |||
| 68364 | 241215 | DPW Maintained 1 | Trachycarpus fortunei :: Windmill Palm 116 | 2801 17th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 14 | Width 3ft | 6008984.20306 | 2106349.91543 | 37.7641427267158 | -122.412107917041 | (37.7641427267158, -122.412107917041) | 8 | 4 | 7 | 28859 | 19 | |||
| 69421 | 197992 | DPW Maintained 1 | Trachycarpus fortunei :: Windmill Palm 116 | 881 Jamestown Ave | 11 | Sidewalk: Property side : Yard | Tree | Private 2 | 6 | Width 6ft | 6014311.92 | 2089359.19845 | 37.7177872401718 | -122.392492192366 | (37.7177872401718, -122.392492192366) | 10 | 3 | 8 | 58 | 1 | |||
| 69699 | 31970 | Permitted Site 7 | Trachycarpus fortunei :: Windmill Palm 116 | 1350 Florida St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/30/1995 12:00:00 AM | Permit Number 35371 | 6009512.01927897 | 2101306.3823382 | 37.7503239226813 | -122.409926287411 | (37.7503239226813, -122.409926287411) | 2 | 4 | 7 | 28859 | 19 | |||
| 70721 | 241207 | DPW Maintained 1 | Trachycarpus fortunei :: Windmill Palm 116 | 1142 South Van Ness Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | Width 3ft | 6007609.4952 | 2103000.12596 | 37.7548677477628 | -122.416625332187 | (37.7548677477628, -122.416625332187) | 2 | 4 | 7 | 28859 | 19 | |||
| 70826 | 241228 | DPW Maintained 1 | Trachycarpus fortunei :: Windmill Palm 116 | 128 Laidley St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11 | Width 3ft | 6003596.19295 | 2097670.16809 | 37.7400063942798 | -122.430124237037 | (37.7400063942798, -122.430124237037) | 2 | 7 | 5 | 63 | 7 | |||
| 71242 | 136740 | DPW Maintained 1 | Trachycarpus fortunei :: Windmill Palm 116 | 1920 Beach St | 8 | Sidewalk: Property side : Yard | Tree | Private 2 | 12 | Width 6ft | 6000976.88542 | 2121020.42839 | 37.8039716578185 | -122.44085530385 | (37.8039716578185, -122.44085530385) | 13 | 9 | 1 | 57 | 17 | |||
| 71574 | 51838 | DPW Maintained 1 | Trachycarpus fortunei :: Windmill Palm 116 | 135 Morse St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/13/2005 12:00:00 AM | 8 | Permit Number 48065 | 6000803.77084 | 2087905.29553 | 37.7130357386885 | -122.43907959427 | (37.7130357386885, -122.43907959427) | 9 | 7 | 6 | 28861 | 5 | ||
| 74382 | 181317 | DPW Maintained 1 | Trachycarpus fortunei :: Windmill Palm 116 | 2520 Irving St | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 0ft | 5987802.3945 | 2106472.9578 | 37.7632693181117 | -122.48537777809 | (37.7632693181117, -122.48537777809) | 1 | 8 | 3 | 56 | 35 | |||
| 74589 | 198001 | DPW Maintained 1 | Trachycarpus fortunei :: Windmill Palm 116 | 860x Jamestown Ave | 1 | Median : Cutout | Tree | DPW 1 | 9 | Width 5ft | 6014795.93259 | 2089063.22643 | 37.7170014260431 | -122.390798490171 | (37.7170014260431, -122.390798490171) | 10 | 3 | 8 | 58 | 1 | |||
| 75935 | 241200 | DPW Maintained 1 | Trachycarpus fortunei :: Windmill Palm 116 | 26 Carl St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | Width 4ft | 5998502.5017 | 2107263.12139 | 37.7660564705643 | -122.448426703328 | (37.7660564705643, -122.448426703328) | 15 | 5 | 11 | 29492 | 9 | |||
| 76957 | 241198 | DPW Maintained 1 | Trachycarpus fortunei :: Windmill Palm 116 | 106 Chattanooga St | 5 | Sidewalk: Curb side : Pot | Tree | Private 2 | 3 | Width 4ft | 6004702.81282 | 2102995.20065 | 37.7546903196133 | -122.426677105059 | (37.7546903196133, -122.426677105059) | 2 | 4 | 5 | 28862 | 22 | |||
| 77167 | 179962 | DPW Maintained 1 | Trachycarpus fortunei :: Windmill Palm 116 | 299 Lathrop Ave | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 3ft | 6012155.6977 | 2086855.92901 | 37.710793783685 | -122.399769664656 | (37.710793783685, -122.399769664656) | 10 | 3 | 8 | 309 | 1 | |||
| 77815 | 241226 | DPW Maintained 1 | Trachycarpus fortunei :: Windmill Palm 116 | 102 Laidley St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | Width 3ft | 6003452.26052 | 2097778.5444 | 37.7402958176893 | -122.43062962727 | (37.7402958176893, -122.43062962727) | 2 | 7 | 5 | 63 | 7 | |||
| 77927 | 187639 | Planning Code 138.1 required 2 | Trachycarpus fortunei :: Windmill Palm 116 | 1671 34th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 02/22/2017 12:00:00 AM | 3 | 3x6 | 5985585 | 2103854 | 37.7559489545124 | -122.492853989295 | (37.7559489545124, -122.492853989295) | 1 | 8 | 3 | 56 | 35 | ||
| 78212 | 110349 | DPW Maintained 1 | Trachycarpus fortunei :: Windmill Palm 116 | 1948 Irving St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | 3x3 | 5989635.8842 | 2106540.7717 | 37.7635621624427 | -122.479041373687 | (37.7635621624427, -122.479041373687) | 1 | 8 | 3 | 56 | 35 | |||
| 79613 | 83166 | DPW Maintained 1 | Trachycarpus fortunei :: Windmill Palm 116 | 1089 Gilman Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/02/2009 12:00:00 AM | 7 | 3x3 | Permit Number 52361 | 6015096.6014 | 2089812.1317 | 37.719074451264 | -122.389811494874 | (37.719074451264, -122.389811494874) | 10 | 3 | 8 | 58 | 1 | |
| 79635 | 197994 | DPW Maintained 1 | Trachycarpus fortunei :: Windmill Palm 116 | 881 Jamestown Ave | 14 | Sidewalk: Property side : Yard | Tree | Private 2 | 9 | Width 6ft | 6014370.9162 | 2089321.9827 | 37.7176883291426 | -122.392285665748 | (37.7176883291426, -122.392285665748) | 10 | 3 | 8 | 58 | 1 | |||
| 80961 | 241221 | DPW Maintained 1 | Trachycarpus fortunei :: Windmill Palm 116 | 2800 17th St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 3ft | 6009078.922 | 2106403.19833 | 37.764294343423 | -122.411784075669 | (37.764294343423, -122.411784075669) | 8 | 4 | 7 | 28859 | 19 | |||
| 81429 | 39859 | Permitted Site 7 | Trachycarpus fortunei :: Windmill Palm 116 | 70 13th St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 01/18/2008 12:00:00 AM | 3x3 | Permit Number 50122 | 6008235.62773227 | 2108364.64558499 | 37.7696326766808 | -122.414839630355 | (37.7696326766808, -122.414839630355) | 8 | 4 | 9 | 28853 | 19 | ||
| 81686 | 16227 | DPW Maintained 1 | Trachycarpus fortunei :: Windmill Palm 116 | 564X Monterey Blvd | 1 | Median : Cutout | Tree | DPW 1 | 02/02/2003 12:00:00 AM | 12 | 5 | 5998342.2808419 | 2094738.2735002 | 37.7316571419822 | -122.44807897208 | (37.7316571419822, -122.44807897208) | 9 | 7 | 4 | 59 | 40 | ||
| 82012 | 181620 | DPW Maintained 1 | Trachycarpus fortunei :: Windmill Palm 116 | 2340 Irving St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | 3x3 | 5988409.299 | 2106492.1372 | 37.7633573181337 | -122.483280127139 | (37.7633573181337, -122.483280127139) | 1 | 8 | 3 | 56 | 35 | |||
| 84020 | 106777 | DPW Maintained 1 | Trachycarpus fortunei :: Windmill Palm 116 | 1177 De Haro St | 2 | Sidewalk: Property side : Cutout | Tree | Private 2 | 06/03/2014 12:00:00 AM | 5 | Permit Number 773142 | 6012265.00001 | 2102937.69671 | 37.7549570630325 | -122.400520812589 | (37.7549570630325, -122.400520812589) | 10 | 3 | 8 | 28856 | 29 | ||
| 84384 | 241181 | DPW Maintained 1 | Trachycarpus fortunei :: Windmill Palm 116 | 300 Duboce Ave | 4 | Front Yard : Yard | Tree | Private 2 | 02/20/2001 12:00:00 AM | 8 | Width 3ft | Permit Number 43693 | 6004757.30529 | 2108409.26199 | 37.7695591257908 | -122.42687421397 | (37.7695591257908, -122.42687421397) | 7 | 9 | 5 | 28862 | 10 | |
| 84902 | 179955 | DPW Maintained 1 | Trachycarpus fortunei :: Windmill Palm 116 | 78 Sala Ter | 2 | Sidewalk: Property side : Yard | Tree | Private 2 | 16 | Width 6ft | 5998862.1125 | 2088471.16796 | 37.7144788232093 | -122.445831259031 | (37.7144788232093, -122.445831259031) | 9 | 7 | 6 | 28861 | 25 | |||
| 84993 | 253492 | Planning Code 138.1 required 2 | Trachycarpus fortunei :: Windmill Palm 116 | 1x Gordon St | 10 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 09/12/2017 12:00:00 AM | 3 | 3x3 | Permit Number 772214 | 6009763 | 2109812 | 37.7736924789578 | -122.409658650953 | (37.7736924789578, -122.409658650953) | 8 | 2 | 9 | 28853 | 34 | |
| 85163 | 136748 | DPW Maintained 1 | Trachycarpus fortunei :: Windmill Palm 116 | 165 Marina Blvd | 2 | Sidewalk: Property side : Yard | Tree | Private 2 | 4 | Width 7ft | 6002698.42353 | 2121575.97678 | 37.8055949413272 | -122.434937570523 | (37.8055949413272, -122.434937570523) | 13 | 9 | 1 | 57 | 17 | |||
| 85377 | 253490 | Planning Code 138.1 required 2 | Trachycarpus fortunei :: Windmill Palm 116 | 1x Gordon St | 8 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 09/12/2017 12:00:00 AM | 3 | 3x3 | Permit Number 772214 | 6009763 | 2109812 | 37.7736924789578 | -122.409658650953 | (37.7736924789578, -122.409658650953) | 8 | 2 | 9 | 28853 | 34 | |
| 85554 | 215428 | DPW Maintained 1 | Trachycarpus fortunei :: Windmill Palm 116 | 20 Lakewood Ave | 7 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | Width 3ft | 5993651.19736 | 2093024.90181 | 37.7266833644367 | -122.464172514845 | (37.7266833644367, -122.464172514845) | 9 | 8 | 4 | 59 | 40 | |||
| 85930 | 215438 | DPW Maintained 1 | Trachycarpus fortunei :: Windmill Palm 116 | 217 Staples Ave | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11 | Width 2ft | 5998696.43814 | 2093778.97623 | 37.7290433761531 | -122.446785584491 | (37.7290433761531, -122.446785584491) | 9 | 7 | 4 | 28861 | 40 | |||
| 86595 | 60204 | DPW Maintained 1 | Trachycarpus fortunei :: Windmill Palm 116 | 1400 16th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/04/1982 12:00:00 AM | 8 | 4x4 | Permit Number 19750 | 6012229.2906 | 2107053.9352 | 37.7662573509097 | -122.400933496957 | (37.7662573509097, -122.400933496957) | 14 | 3 | 8 | 28853 | 20 | |
| 87387 | 241193 | DPW Maintained 1 | Trachycarpus fortunei :: Windmill Palm 116 | 699 Hampshire St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 3ft | 6010149.76354 | 2105082.07302 | 37.7607268479899 | -122.407987146983 | (37.7607268479899, -122.407987146983) | 10 | 4 | 8 | 28859 | 19 | |||
| 88233 | 83362 | DPW Maintained 1 | Trachycarpus fortunei :: Windmill Palm 116 | 3325 Rivera St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/01/2008 12:00:00 AM | 5 | 3x3 | Permit Number 51120 | 5982822.4546 | 2100126.935 | 37.7455535383912 | -122.502131834041 | (37.7455535383912, -122.502131834041) | 1 | 8 | 3 | 29491 | 35 | |
| 88243 | 241217 | DPW Maintained 1 | Trachycarpus fortunei :: Windmill Palm 116 | 4130 Cesar Chavez St | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 9 | Width 6ft | 6003092.5802 | 2100398.11558 | 37.7474681682247 | -122.432060274186 | (37.7474681682247, -122.432060274186) | 2 | 4 | 5 | 63 | 22 | |||
| 89456 | 42310 | Permitted Site 7 | Trachycarpus fortunei :: Windmill Palm 116 | 249 Edna St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/23/2000 12:00:00 AM | Permit Number 42531 | 5998732.34943109 | 2093642.59637242 | 37.7286709604577 | -122.446651628377 | (37.7286709604577, -122.446651628377) | 9 | 7 | 4 | 28861 | 40 | |||
| 90053 | 182351 | DPW Maintained 1 | Trachycarpus fortunei :: Windmill Palm 116 | 1501 35th Ave | 2 | Sidewalk: Curb side : Yard | Tree | Private 2 | 10 | Width 0ft | 5985257.4301 | 2104935.3862 | 37.758898980602 | -122.49406651392 | (37.758898980602, -122.49406651392) | 1 | 8 | 3 | 56 | 35 | |||
| 91219 | 108286 | Undocumented 4 | Trachycarpus fortunei :: Windmill Palm 116 | 1 HENRY ADAMS ST | 11 | Sidewalk: Property side : Cutout | Tree | Private 2 | 3x3 | 6011517.4 | 2108140.5 | 37.7692010762684 | -122.403472255644 | (37.7692010762684, -122.403472255644) | 8 | 2 | 8 | 28853 | 20 | ||||
| 91363 | 241216 | DPW Maintained 1 | Trachycarpus fortunei :: Windmill Palm 116 | 6 Fountain St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 24 | Width 3ft | 6000321.631 | 2101619.05614 | 37.7506630907493 | -122.441729618453 | (37.7506630907493, -122.441729618453) | 2 | 4 | 5 | 28862 | 22 | |||
| 91808 | 88373 | Permitted Site 7 | Trachycarpus fortunei :: Windmill Palm 116 | 45 Sheridan St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/20/2005 12:00:00 AM | 2x3 | Permit Number 48123 | 6009306 | 2109414 | 37.7725740445577 | -122.411211370961 | (37.7725740445577, -122.411211370961) | 8 | 2 | 9 | 28853 | 34 | ||
| 92770 | 258425 | DPW Maintained 1 | Trachycarpus fortunei :: Windmill Palm 116 | 2100 Irving St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 5989196 | 2106551 | 37.7635646915697 | -122.480563525243 | (37.7635646915697, -122.480563525243) | 1 | 8 | 3 | 56 | 35 | ||||
| 93105 | 253487 | Planning Code 138.1 required 2 | Trachycarpus fortunei :: Windmill Palm 116 | 1x Gordon St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 09/12/2017 12:00:00 AM | 3 | 3x3 | Permit Number 772214 | 6009763 | 2109812 | 37.7736924789578 | -122.409658650953 | (37.7736924789578, -122.409658650953) | 8 | 2 | 9 | 28853 | 34 | |
| 95654 | 253488 | Planning Code 138.1 required 2 | Trachycarpus fortunei :: Windmill Palm 116 | 1x Gordon St | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 09/12/2017 12:00:00 AM | 3 | 3x3 | Permit Number 772214 | 6009763 | 2109812 | 37.7736924789578 | -122.409658650953 | (37.7736924789578, -122.409658650953) | 8 | 2 | 9 | 28853 | 34 | |
| 96141 | 197984 | DPW Maintained 1 | Trachycarpus fortunei :: Windmill Palm 116 | 1177 De Haro St | 3 | Sidewalk: Property side : Yard | Tree | Private 2 | 5 | Width 4ft | 6012264.79545 | 2102939.83963 | 37.7549629356143 | -122.40052167054 | (37.7549629356143, -122.40052167054) | 10 | 3 | 8 | 28856 | 29 | |||
| 96325 | 241195 | DPW Maintained 1 | Trachycarpus fortunei :: Windmill Palm 116 | 699 Hampshire St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 3ft | 6010149.31923 | 2105113.84294 | 37.7608140561404 | -122.407990924146 | (37.7608140561404, -122.407990924146) | 10 | 4 | 8 | 28859 | 19 | |||
| 96573 | 258416 | DPW Maintained 1 | Trachycarpus fortunei :: Windmill Palm 116 | 1825 Irving St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | Width 0ft | 5990038 | 2106473 | 37.7633994233021 | -122.477645643383 | (37.7633994233021, -122.477645643383) | 1 | 8 | 3 | 56 | 35 | ||||
| 96877 | 16284 | DPW Maintained 1 | Trachycarpus fortunei :: Windmill Palm 116 | 700X Monterey Blvd | 1 | Median : Cutout | Tree | DPW 1 | 02/02/2003 12:00:00 AM | 12 | G | 5997448.036427 | 2094744.2173306 | 37.7316223027997 | -122.45117096627 | (37.7316223027997, -122.45117096627) | 9 | 7 | 4 | 59 | 40 | ||
| 97492 | 197999 | DPW Maintained 1 | Trachycarpus fortunei :: Windmill Palm 116 | 828 Jamestown Ave | 1 | : | Tree | Private 2 | 10 | Width 5ft | 6014890.34253 | 2088931.57147 | 37.7166451650195 | -122.390462963914 | (37.7166451650195, -122.390462963914) | 10 | 3 | 8 | 58 | 1 | |||
| 98290 | 82840 | DPW Maintained 1 | Trachycarpus fortunei :: Windmill Palm 116 | 1379 Quesada Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/08/2009 12:00:00 AM | 13 | 3x3 | Permit Number 52465 | 6016423.5899 | 2093711.7525 | 37.729855545757 | -122.385496180523 | (37.729855545757, -122.385496180523) | 10 | 3 | 8 | 58 | 1 | |
| 98496 | 198004 | DPW Maintained 1 | Trachycarpus fortunei :: Windmill Palm 116 | 920x Jamestown Ave | 12 | Median : Cutout | Tree | DPW 1 | 10 | Width 5ft | 6014389.31588 | 2089371.37328 | 37.7178249676301 | -122.392225518194 | (37.7178249676301, -122.392225518194) | 10 | 3 | 8 | 58 | 1 | |||
| 99590 | 241201 | DPW Maintained 1 | Trachycarpus fortunei :: Windmill Palm 116 | 26 Carl St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11 | Width 4ft | 5998490.81522 | 2107264.49374 | 37.7660595705173 | -122.448467223189 | (37.7660595705173, -122.448467223189) | 15 | 5 | 11 | 29492 | 9 | |||
| 99771 | 241212 | DPW Maintained 1 | Trachycarpus fortunei :: Windmill Palm 116 | 2801 17th St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11 | Width 3ft | 6009052.89196 | 2106353.81264 | 37.7641572813666 | -122.411870616529 | (37.7641572813666, -122.411870616529) | 8 | 4 | 7 | 28859 | 19 | |||
| 100358 | 4167 | DPW Maintained 1 | Trachycarpus fortunei :: Windmill Palm 116 | 3781 Cesar Chavez St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 01/04/1993 12:00:00 AM | 12 | 3X3 | 6005338.8489102 | 2100470.98597 | 37.7477953482432 | -122.424297997893 | (37.7477953482432, -122.424297997893) | 2 | 4 | 5 | 28859 | 22 | ||
| 100468 | 16027 | DPW Maintained 1 | Trachycarpus fortunei :: Windmill Palm 116 | 160 Monterey Blvd | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 02/23/2005 12:00:00 AM | 3 | 3X3 | 6001078.56062 | 2094701.12537 | 37.7317111799206 | -122.438616467699 | (37.7317111799206, -122.438616467699) | 9 | 7 | 4 | 63 | 40 | ||
| 102004 | 124330 | DPW Maintained 1 | Trachycarpus fortunei :: Windmill Palm 116 | 130 Palm Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 3ft | 5995934.00049 | 2113471.95009 | 37.7829570979054 | -122.457759890544 | (37.7829570979054, -122.457759890544) | 11 | 6 | 1 | 54 | 31 | |||
| 103122 | 241199 | DPW Maintained 1 | Trachycarpus fortunei :: Windmill Palm 116 | 24 Carl St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 4ft | 5998508.2304 | 2107266.01278 | 37.7660647371231 | -122.448407097228 | (37.7660647371231, -122.448407097228) | 15 | 5 | 11 | 29492 | 9 | |||
| 103790 | 179968 | DPW Maintained 1 | Trachycarpus fortunei :: Windmill Palm 116 | 675 Silver Ave | 3 | Sidewalk: Property side : Yard | Tree | Private 2 | 32 | Width 2ft | 6005852.39602 | 2093589.23287 | 37.7289285803821 | -122.422033372066 | (37.7289285803821, -122.422033372066) | 9 | 7 | 6 | 28861 | 5 | |||
| 104413 | 241223 | DPW Maintained 1 | Trachycarpus fortunei :: Windmill Palm 116 | 2800 17th St | 7 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 3ft | 6009004.56515 | 2106399.07167 | 37.7642788409211 | -122.412040964327 | (37.7642788409211, -122.412040964327) | 8 | 4 | 7 | 28859 | 19 | |||
| 104558 | 181643 | DPW Maintained 1 | Trachycarpus fortunei :: Windmill Palm 116 | 2520 Irving St | 7 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | 3x3 | 5987777.5915 | 2106472.9578 | 37.7632678730962 | -122.485463562399 | (37.7632678730962, -122.485463562399) | 1 | 8 | 3 | 56 | 35 | |||
| 104861 | 258421 | DPW Maintained 1 | Trachycarpus fortunei :: Windmill Palm 116 | 1899 Irving St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | Width 0ft | 5989890 | 2106503 | 37.7634732054208 | -122.478159715367 | (37.7634732054208, -122.478159715367) | 1 | 8 | 3 | 56 | 35 | ||||
| 104918 | 241194 | DPW Maintained 1 | Trachycarpus fortunei :: Windmill Palm 116 | 699 Hampshire St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 3ft | 6010150.13435 | 2105098.12881 | 37.7607709543248 | -122.4079869968 | (37.7607709543248, -122.4079869968) | 10 | 4 | 8 | 28859 | 19 | |||
| 105665 | 253493 | Planning Code 138.1 required 2 | Trachycarpus fortunei :: Windmill Palm 116 | 1x Gordon St | 11 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 09/12/2017 12:00:00 AM | 3 | 3x3 | Permit Number 772214 | 6009763 | 2109812 | 37.7736924789578 | -122.409658650953 | (37.7736924789578, -122.409658650953) | 8 | 2 | 9 | 28853 | 34 | |
| 106666 | 108225 | Permitted Site 7 | Trachycarpus fortunei :: Windmill Palm 116 | 240 Shotwell St | 14 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6007737.2 | 2106597 | 37.7647511168143 | -122.416438454623 | (37.7647511168143, -122.416438454623) | 8 | 4 | 7 | 28859 | 19 | ||||
| 106828 | 181621 | DPW Maintained 1 | Trachycarpus fortunei :: Windmill Palm 116 | 2340 Irving St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | 3x3 | 5988377.8972 | 2106492.1372 | 37.7633554905962 | -122.483388734412 | (37.7633554905962, -122.483388734412) | 1 | 8 | 3 | 56 | 35 | |||
| 107025 | 182656 | DPW Maintained 1 | Trachycarpus fortunei :: Windmill Palm 116 | 2618 Ortega St | 3 | Sidewalk: Curb side : Yard | Tree | Private 2 | 7 | Width 0ft | 5985872.0635 | 2102330.847 | 37.7517835760889 | -122.491749119446 | (37.7517835760889, -122.491749119446) | 1 | 8 | 3 | 56 | 35 | |||
| 107491 | 258427 | DPW Maintained 1 | Trachycarpus fortunei :: Windmill Palm 116 | 2142 Irving St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 5989006 | 2106545 | 37.7635371731016 | -122.481220228107 | (37.7635371731016, -122.481220228107) | 1 | 8 | 3 | 56 | 35 | ||||
| 108025 | 241204 | DPW Maintained 1 | Trachycarpus fortunei :: Windmill Palm 116 | 2399 Folsom St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 4ft | 6008220.32471 | 2104519.20022 | 37.7590731143473 | -122.414620398932 | (37.7590731143473, -122.414620398932) | 2 | 4 | 7 | 28859 | 19 | |||
| 109219 | 241183 | DPW Maintained 1 | Trachycarpus fortunei :: Windmill Palm 116 | 1720 Dolores St | 5 | Sidewalk: Property side : Yard | Tree | Private 2 | 3 | Width 3ft | 6005264.11037 | 2098316.58265 | 37.7418756279601 | -122.424403226839 | (37.7418756279601, -122.424403226839) | 2 | 7 | 5 | 63 | 7 | |||
| 109574 | 215417 | DPW Maintained 1 | Trachycarpus fortunei :: Windmill Palm 116 | 286 Orizaba Ave | 2 | Sidewalk: Curb side : Pot | Tree | Private 2 | 12 | 5994025.97554 | 2088461.57938 | 37.7141751725286 | -122.462546063947 | (37.7141751725286, -122.462546063947) | 9 | 8 | 6 | 28861 | 24 | ||||
| 110288 | 241190 | DPW Maintained 1 | Trachycarpus fortunei :: Windmill Palm 116 | 2858 25th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 3ft | 6010222.30692 | 2101664.86224 | 37.7513480117 | -122.407495323966 | (37.7513480117, -122.407495323966) | 2 | 4 | 7 | 28859 | 19 | |||
| 110485 | 44261 | Permitted Site 7 | Trachycarpus fortunei :: Windmill Palm 116 | 300 Duboce Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 02/20/2001 12:00:00 AM | Permit Number 43693 | 6004891.25445895 | 2108442.06671817 | 37.7696567724968 | -122.426413224583 | (37.7696567724968, -122.426413224583) | 7 | 4 | 5 | 28852 | 10 | |||
| 110492 | 4166 | DPW Maintained 1 | Trachycarpus fortunei :: Windmill Palm 116 | 3771 Cesar Chavez St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 10/18/1999 12:00:00 AM | 3 | 3X3 | 6005390.77926 | 2100476.44824 | 37.747813278574 | -122.424118813557 | (37.747813278574, -122.424118813557) | 2 | 4 | 5 | 28859 | 22 | ||
| 111371 | 255520 | Undocumented 4 | Trachycarpus fortunei :: Windmill Palm 116 | 77 Belgrave Ave | Sidewalk: Property side : Yard | Tree | Private 2 | 10x10 | Permit Number 781419 | 5998149.61527 | 2104897.27011 | 37.7595402565853 | -122.449476776674 | (37.7595402565853, -122.449476776674) | 15 | 5 | 11 | 28862 | 12 | ||||
| 111572 | 57900 | DPW Maintained 1 | Trachycarpus fortunei :: Windmill Palm 116 | 1324 Hayes St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/09/1977 12:00:00 AM | 5 | Permit Number 16856 | 6001502.5818 | 2110462.7186 | 37.7750128394498 | -122.438279288937 | (37.7750128394498, -122.438279288937) | 15 | 5 | 11 | 29492 | 10 | ||
| 111657 | 241225 | DPW Maintained 1 | Trachycarpus fortunei :: Windmill Palm 116 | 4049 17th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 2ft | 6001920.58101 | 2105839.72544 | 37.7623430070574 | -122.436502382779 | (37.7623430070574, -122.436502382779) | 15 | 5 | 5 | 28862 | 3 | |||
| 112010 | 136751 | DPW Maintained 1 | Trachycarpus fortunei :: Windmill Palm 116 | 1142 Filbert St | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 12 | Width 3ft | 6007453.51921 | 2119553.70533 | 37.8003111329029 | -122.41833837522 | (37.8003111329029, -122.41833837522) | 5 | 1 | 1 | 28858 | 32 | |||
| 112047 | 66205 | Permitted Site 7 | Trachycarpus fortunei :: Windmill Palm 116 | 285 Mullen Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/03/1990 12:00:00 AM | Permit Number 29289 | 6010420.85602386 | 2100006.0506029 | 37.746804390663 | -122.406691826217 | (37.746804390663, -122.406691826217) | 2 | 7 | 7 | 28859 | 2 | |||
| 112460 | 85491 | Permitted Site 7 | Trachycarpus fortunei :: Windmill Palm 116 | 4400 24th St | Sidewalk: Curb side : Cutout | Tree | Private 2 | 09/05/2007 12:00:00 AM | 3x3 | Permit Number 52154 | 6000641 | 2101716 | 37.7509474670616 | -122.440632169404 | (37.7509474670616, -122.440632169404) | 2 | 4 | 5 | 28862 | 22 | |||
| 112628 | 83941 | Permitted Site 7 | Trachycarpus fortunei :: Windmill Palm 116 | 60 13th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 01/18/2008 12:00:00 AM | 3X3 | Permit Number 50121 | 6008302.41836553 | 2108360.42350377 | 37.7696248364946 | -122.414608304259 | (37.7696248364946, -122.414608304259) | 8 | 4 | 9 | 28853 | 19 | ||
| 113741 | 117606 | Permitted Site 7 | Trachycarpus fortunei :: Windmill Palm 116 | 420 Castro St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | 3X3 | 6002292.2454566 | 2105806.2278627 | 37.7622721434766 | -122.435214539817 | (37.7622721434766, -122.435214539817) | 15 | 4 | 5 | 28862 | 3 | |||
| 114053 | 181367 | DPW Maintained 1 | Trachycarpus fortunei :: Windmill Palm 116 | 4019 Judah St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 0ft | 5982046.1498 | 2105540.3564 | 37.7603716302877 | -122.505217265817 | (37.7603716302877, -122.505217265817) | 1 | 8 | 3 | 56 | 35 | |||
| 114110 | 66988 | DPW Maintained 1 | Trachycarpus fortunei :: Windmill Palm 116 | 1445 Green St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 02/12/1992 12:00:00 AM | 12 | Permit Number 30339 | 6006117.71616 | 2118619.27503 | 37.7976701397196 | -122.422894339811 | (37.7976701397196, -122.422894339811) | 13 | 9 | 10 | 28858 | 32 | ||
| 114123 | 36797 | DPW Maintained 1 | Trachycarpus fortunei :: Windmill Palm 116 | 1350 Donner Ave | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/26/1998 12:00:00 AM | 8 | 3x3 | Permit Number 39527 | 6015213.5435 | 2090847.5562 | 37.7219240080036 | -122.389479539312 | (37.7219240080036, -122.389479539312) | 10 | 3 | 8 | 58 | 1 | |
| 114315 | 108221 | Permitted Site 7 | Trachycarpus fortunei :: Windmill Palm 116 | 240 Shotwell St | 10 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6007737.2 | 2106597 | 37.7647511168143 | -122.416438454623 | (37.7647511168143, -122.416438454623) | 8 | 4 | 7 | 28859 | 19 | ||||
| 114591 | 258438 | DPW Maintained 1 | Trachycarpus fortunei :: Windmill Palm 116 | 2425 Irving St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 5988206.1929 | 2106434.2769 | 37.7631866273281 | -122.483978353246 | (37.7631866273281, -122.483978353246) | 1 | 8 | 3 | 56 | 35 | ||||
| 115633 | 16314 | DPW Maintained 1 | Trachycarpus fortunei :: Windmill Palm 116 | 758X Monterey Blvd | 6 | Median : Cutout | Tree | DPW 1 | 02/02/2003 12:00:00 AM | 12 | 5 | 5997070.7706475 | 2094757.2260752 | 37.7316364140758 | -122.452476180169 | (37.7316364140758, -122.452476180169) | 9 | 7 | 4 | 59 | 40 | ||
| 115769 | 258422 | DPW Maintained 1 | Trachycarpus fortunei :: Windmill Palm 116 | 1916 Irving St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 5989767 | 2106571 | 37.7636527745423 | -122.478590101352 | (37.7636527745423, -122.478590101352) | 1 | 8 | 3 | 56 | 35 | ||||
| 116024 | 39860 | Permitted Site 7 | Trachycarpus fortunei :: Windmill Palm 116 | 70 13th St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 01/18/2008 12:00:00 AM | 3x3 | Permit Number 50122 | 6008235.62773227 | 2108364.64558499 | 37.7696326766808 | -122.414839630355 | (37.7696326766808, -122.414839630355) | 8 | 4 | 9 | 28853 | 19 | ||
| 116195 | 42309 | Permitted Site 7 | Trachycarpus fortunei :: Windmill Palm 116 | 249 Edna St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/23/2000 12:00:00 AM | Permit Number 42531 | 5998732.34943109 | 2093642.59637242 | 37.7286709604577 | -122.446651628377 | (37.7286709604577, -122.446651628377) | 9 | 7 | 4 | 28861 | 40 |
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) );