trees
7,157 rows where qSpecies_id = 36
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) |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
2946 | 211579 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 80 San Fernando Way | 2 | Sidewalk: Curb side : Yard | Tree | Private 2 | 21 | Width 8ft | 5992099.63663 | 2096102.89356 | 37.7350452131685 | -122.469760152011 | (37.7350452131685, -122.469760152011) | 1 | 8 | 4 | 59 | 40 | |||
2958 | 71259 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 1645 Golden Gate Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 9 | 6001742.1262 | 2111827.7039 | 37.7787743674935 | -122.437548426148 | (37.7787743674935, -122.437548426148) | 15 | 5 | 11 | 29490 | 41 | |||
2990 | 9645 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 1521 Golden Gate Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | 3X3 | 6002120.8202 | 2111880.4977 | 37.7789408493567 | -122.436242156437 | (37.7789408493567, -122.436242156437) | 15 | 5 | 11 | 29490 | 41 | |||
3104 | 71279 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 2922 Octavia St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 8 | 6004338.76046 | 2119216.84729 | 37.7992103816196 | -122.429092640025 | (37.7992103816196, -122.429092640025) | 13 | 9 | 1 | 57 | 17 | |||
3131 | 66639 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 1047 Bush St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/05/1991 12:00:00 AM | 8 | Permit Number 29850 | 6008486.64732 | 2115539.47023 | 37.7893471345134 | -122.414479125336 | (37.7893471345134, -122.414479125336) | 5 | 1 | 10 | 28858 | 21 | |
3179 | 8036 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 555 Fulton St | 9 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 6 | 3X3 | 6005091.683 | 2111605.7953 | 37.7783549305744 | -122.425945187873 | (37.7783549305744, -122.425945187873) | 7 | 9 | 11 | 28852 | 10 | |||
3188 | 260646 | Significant Tree 6 | Pittosporum undulatum :: Victorian Box 36 | 3905 Sacramento St | 2 | Sidewalk: Property side : Cutout | Tree | Private 2 | 3x3 | 5996106 | 2114850 | 37.7867507340863 | -122.457264569448 | (37.7867507340863, -122.457264569448) | 11 | 6 | 1 | 54 | 31 | ||||
3202 | 236044 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 45 Noe St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 11/15/2016 12:00:00 AM | 2 | Width 3ft | 6002861.69215 | 2108022.66874 | 37.7683902715159 | -122.433403433237 | (37.7683902715159, -122.433403433237) | 15 | 5 | 5 | 28862 | 3 | ||
3235 | 225279 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 125 Alma St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 2ft | 5998048.35384 | 2106192.09719 | 37.7630897330321 | -122.449920306376 | (37.7630897330321, -122.449920306376) | 15 | 5 | 11 | 29492 | 9 | |||
3327 | 99692 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 1550X Washington St | 3 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | DPW for City Agency | 8 | 2x2 | 6007274.7 | 2117123.2 | 37.7936275055362 | -122.418784695641 | (37.7936275055362, -122.418784695641) | 5 | 1 | 10 | 28858 | 32 | ||
3328 | 235080 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 1199X Shrader St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 21 | Width 3ft | 5997665 | 2106510 | 37.7639406713752 | -122.451269119462 | (37.7639406713752, -122.451269119462) | 15 | 5 | 11 | 29492 | 9 | |||
3350 | 258099 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 250 Woolsey St | 1 | Sidewalk: Curb side : | Tree | DPW 1 | 3 | 4x5 | 6011000.65781 | 2092015.53827 | 37.7248965615024 | -122.404124654724 | (37.7248965615024, -122.404124654724) | 10 | 3 | 7 | 309 | 28 | |||
3375 | 261255 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 245 Euclid Ave | 3 | Sidewalk: Property side : Cutout | Tree | Private 2 | 12/18/2019 12:00:00 AM | 3 | 5998181.06314 | 2113969.03195 | 37.7844507871641 | -122.450021856673 | (37.7844507871641, -122.450021856673) | 15 | 6 | 1 | 54 | 31 | |||
3386 | 74868 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 101 Laurel St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 6 | 5997976.38081 | 2116093.74449 | 37.7902729712773 | -122.450883240175 | (37.7902729712773, -122.450883240175) | 11 | 6 | 1 | 54 | 31 | |||
3427 | 211709 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 253 Farallones St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 13 | Width 3ft | 5994473.10989 | 2088383.38682 | 37.7139862141701 | -122.460994942073 | (37.7139862141701, -122.460994942073) | 9 | 8 | 6 | 28861 | 24 | |||
3463 | 72267 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 366 Paris St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 9 | 6002326.2319 | 2091479.20483 | 37.7229354119295 | -122.43407278875 | (37.7229354119295, -122.43407278875) | 9 | 7 | 6 | 28861 | 5 | |||
3478 | 124312 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 137 Jordan Ave | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 6 | Width 4ft | 5996200.49835 | 2113470.04705 | 37.782967178816 | -122.456837786082 | (37.782967178816, -122.456837786082) | 11 | 6 | 1 | 54 | 31 | |||
3629 | 140363 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 1750 O'Farrell St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 0ft | 6002930.8274 | 2113434.8001 | 37.7832545622139 | -122.433551128922 | (37.7832545622139, -122.433551128922) | 13 | 9 | 11 | 29490 | 41 | |||
3697 | 114907 | Undocumented 4 | Pittosporum undulatum :: Victorian Box 36 | 248 LOBOS ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | 3x3 | 5994525 | 2088748 | 37.7149903414399 | -122.460842000428 | (37.7149903414399, -122.460842000428) | 9 | 8 | 6 | 28861 | 24 | |||
3738 | 120612 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 2 North Point St | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 01/17/2020 12:15:00 PM | 3 | 3x3 | 6010461.28086 | 2122053.16069 | 37.8073428708526 | -122.408106655207 | (37.8073428708526, -122.408106655207) | 3 | 1 | 10 | 308 | 23 | ||
3745 | 234320 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 393 San Jose Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 16 | Width 3ft | 6006234.26567 | 2100922.612 | 37.749085930782 | -122.421233751538 | (37.749085930782, -122.421233751538) | 2 | 4 | 5 | 28859 | 19 | |||
3749 | 133080 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 1323 Filbert St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 13 | Width 3ft | 6006658.05063 | 2119385.33071 | 37.7998040088165 | -122.421079053765 | (37.7998040088165, -122.421079053765) | 13 | 9 | 1 | 28858 | 32 | |||
3751 | 132937 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 2459 Buchanan St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 4ft | 6003649.5548 | 2116872.9582 | 37.7927356271009 | -122.431310124485 | (37.7927356271009, -122.431310124485) | 13 | 9 | 1 | 29490 | 27 | |||
3793 | 66047 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 465 Avila St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 08/18/1990 12:00:00 AM | 9 | Permit Number 29210 | 6001137.14728 | 2121594.78406 | 37.8055578110078 | -122.440341924044 | (37.8055578110078, -122.440341924044) | 13 | 9 | 1 | 57 | 17 | |
3809 | 56544 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 2001 21st Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 6 | 5989711.5047 | 2101688.7123 | 37.7502440940639 | -122.478425007726 | (37.7502440940639, -122.478425007726) | 1 | 8 | 3 | 29491 | 35 | |||
3878 | 14819 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 1234 McAllister St | 5 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 4X4 | 6003219.5071 | 2111735.2352 | 37.7786043572111 | -122.432430984172 | (37.7786043572111, -122.432430984172) | 15 | 9 | 11 | 29490 | 41 | |||
3901 | 8039 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 555 Fulton St | 12 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 14 | 3X3 | 6005222.0085 | 2111622.3531 | 37.778407758667 | -122.425495521768 | (37.778407758667, -122.425495521768) | 7 | 9 | 11 | 28852 | 10 | |||
3976 | 75213 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 125 Excelsior Ave | 2 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | DPW for City Agency | 10 | 4x5 | 6002883.60734 | 2092451.48886 | 37.7256367037627 | -122.43221546119 | (37.7256367037627, -122.43221546119) | 9 | 7 | 6 | 28861 | 5 | ||
3982 | 1590 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 672 Arguello Blvd | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 20 | 3x3 | 5995676.64929 | 2111528.6182 | 37.7776064376136 | -122.458509495126 | (37.7776064376136, -122.458509495126) | 11 | 6 | 2 | 54 | 16 | |||
4007 | 61209 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 130 Elmira St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 11/17/1983 12:00:00 AM | 4 | Permit Number 21077 | 6011180.72945 | 2095956.2501 | 37.7357269919001 | -122.403779325271 | (37.7357269919001, -122.403779325271) | 10 | 3 | 8 | 58 | 1 | |
4088 | 32087 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 3964 19th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 08/09/1995 12:00:00 AM | 9 | Permit Number 35460 | 6003256.89159 | 2104790.94057 | 37.759539140336 | -122.431805698599 | (37.759539140336, -122.431805698599) | 2 | 4 | 5 | 28862 | 3 | |
4144 | 194961 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 380 Clementina St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | Width 2ft | 6011578.05189 | 2112446.27024 | 37.7810271186418 | -122.403565445814 | (37.7810271186418, -122.403565445814) | 6 | 2 | 9 | 28853 | 34 | |||
4195 | 206085 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 1226 15th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 3ft | 5991451.67121 | 2107042.34403 | 37.7650446262448 | -122.472797776817 | (37.7650446262448, -122.472797776817) | 11 | 8 | 11 | 56 | 12 | |||
4240 | 181914 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 1840 Taraval St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 09/19/2016 01:32:00 PM | 1 | 3x3 | 5987462 | 2098996 | 37.7427197736461 | -122.486006207543 | (37.7427197736461, -122.486006207543) | 1 | 8 | 3 | 29491 | 35 | ||
4263 | 247985 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 495 Peralta Ave | 1 | Side Yard : Yard | Tree | Private 2 | 7 | 6009773.5395 | 2099699.69988 | 37.7459269802441 | -122.40890858338 | (37.7459269802441, -122.40890858338) | 2 | 7 | 7 | 28859 | 2 | ||||
4265 | 129451 | Permitted Site 7 | Pittosporum undulatum :: Victorian Box 36 | 1147 Filbert St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/20/2018 12:00:00 AM | 3 | 3x3 | Permit Number 779607 | 6007395.89235 | 2119499.90916 | 37.8001601781003 | -122.418533970572 | (37.8001601781003, -122.418533970572) | 5 | 1 | 1 | 28858 | 32 |
4270 | 4929 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 16 Dedman Ct | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 11/16/2013 12:00:00 AM | 3 | 3X4 | 6016491.974751 | 2096204.2192508 | 37.7367031453425 | -122.385433388359 | (37.7367031453425, -122.385433388359) | 10 | 3 | 8 | 58 | 1 | ||
4282 | 64889 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 1380 Greenwich St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/19/2008 12:00:00 AM | 4 | 3x3 | Permit Number 50994 | 6006338.45294 | 2119739.76181 | 37.8007591652634 | -122.422210176984 | (37.8007591652634, -122.422210176984) | 13 | 9 | 1 | 28858 | 32 | |
4306 | 62569 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 554 Kansas St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 01/28/1986 12:00:00 AM | 10 | Permit Number 22770 | 6011490.00486 | 2105779.9506 | 37.7627180099397 | -122.403400924707 | (37.7627180099397, -122.403400924707) | 8 | 3 | 8 | 28856 | 29 | |
4335 | 187271 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 2401 Sunset Blvd | 54 | Sidewalk: Property side : Yard | Landscaping | Private 2 | 5 | Width 0ft | 5984941.9801 | 2098338.6223 | 37.7407676103918 | -122.494671132674 | (37.7407676103918, -122.494671132674) | 1 | 8 | 3 | 29491 | 35 | |||
4369 | 152868 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 12 Oakwood St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 0 | 4xx | 6005222.26295 | 2105379.48024 | 37.7612663458787 | -122.425050338507 | (37.7612663458787, -122.425050338507) | 2 | 4 | 5 | 28859 | 19 | |||
4383 | 132545 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 1990 Beach St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11 | Width 2ft | 6000779.58513 | 2120984.3589 | 37.8038613820664 | -122.441535482685 | (37.8038613820664, -122.441535482685) | 13 | 9 | 1 | 57 | 17 | |||
4445 | 73832 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 2535 25th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 4 | 5988594.7963 | 2098063.4053 | 37.7402250639008 | -122.482021065141 | (37.7402250639008, -122.482021065141) | 1 | 8 | 3 | 29491 | 35 | |||
4506 | 82619 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 1625 Eddy St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 3 | 6002586.1843 | 2112639.7911 | 37.7810521077693 | -122.434686587512 | (37.7810521077693, -122.434686587512) | 15 | 5 | 11 | 29490 | 41 | |||
4528 | 120611 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 2 North Point St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 01/17/2020 12:17:00 PM | 3 | 3x3 | 6010487.77863 | 2122056.40729 | 37.8073532688065 | -122.408015182448 | (37.8073532688065, -122.408015182448) | 3 | 1 | 10 | 308 | 23 | ||
4552 | 250073 | Planning Code 138.1 required 2 | Pittosporum undulatum :: Victorian Box 36 | 1599X Bush St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 04/05/2017 12:00:00 AM | 3 | Width 4ft | Permit Number 770925 | 6006083 | 2115238 | 37.7883840466687 | -122.422774045373 | (37.7883840466687, -122.422774045373) | 13 | 9 | 1 | 28858 | 41 | |
4558 | 211753 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 30 Madrone Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11 | Width 3ft | 5992920.89578 | 2098928.53886 | 37.7428511594615 | -122.467126165439 | (37.7428511594615, -122.467126165439) | 1 | 8 | 4 | 59 | 40 | |||
4607 | 61655 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 115 09th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 11/21/1984 12:00:00 AM | 13 | Permit Number 21645 | 5993010.94505 | 2114713.65731 | 37.7861981288567 | -122.467962713892 | (37.7861981288567, -122.467962713892) | 11 | 6 | 2 | 54 | 11 | |
4657 | 110962 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 2025x Taylor St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 18 | 3x3 | 6008581.83695 | 2119828.07528 | 37.8011279340648 | -122.414453362433 | (37.8011279340648, -122.414453362433) | 5 | 1 | 10 | 308 | 32 | |||
4703 | 91869 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 560 Irving St | 3 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12/10/2008 12:00:00 AM | 3 | 3x3 | 5994058.946883 | 2106681.424686 | 37.7642042246677 | -122.463753726671 | (37.7642042246677, -122.463753726671) | 11 | 5 | 11 | 56 | 12 | ||
4711 | 30383 | Permitted Site 7 | Pittosporum undulatum :: Victorian Box 36 | 2800 Turk St | 14 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 03/09/1956 12:00:00 AM | Permit Number 66 | 5997681.665837 | 2111673.48633421 | 37.7781192320704 | -122.451583952943 | (37.7781192320704, -122.451583952943) | 15 | 6 | 2 | 54 | 16 | |||
4721 | 44169 | Permitted Site 7 | Pittosporum undulatum :: Victorian Box 36 | 2100 Vallejo St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/12/2000 12:00:00 AM | Permit Number 43638 | 6003503.99505303 | 2117958.62597334 | 37.795708342081 | -122.431891323133 | (37.795708342081, -122.431891323133) | 13 | 9 | 1 | 57 | 17 | |||
4744 | 116025 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 1425 Vallejo St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/02/2016 12:00:00 AM | 3 | 3x3 | 6006694.6941 | 2118351.37216 | 37.796967084814 | -122.420878805335 | (37.796967084814, -122.420878805335) | 13 | 9 | 10 | 28858 | 32 | ||
4753 | 137893 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 1700 Bush St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 0ft | 6005266.7921 | 2115153.1008 | 37.7881048492405 | -122.425591951126 | (37.7881048492405, -122.425591951126) | 13 | 9 | 11 | 28858 | 27 | |||
4798 | 138995 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 611 Fillmore St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 0ft | 6003540 | 2110455 | 37.7751073166065 | -122.431230870083 | (37.7751073166065, -122.431230870083) | 15 | 9 | 11 | 29492 | 10 | |||
4820 | 253072 | Planning Code 138.1 required 2 | Pittosporum undulatum :: Victorian Box 36 | 1350 46th Ave | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 12/18/2019 12:00:00 AM | 3 | 6x10 | Permit Number 780489 | 5981849.66657 | 2105897.22193 | 37.7613399178539 | -122.50592325662 | (37.7613399178539, -122.50592325662) | 1 | 8 | 3 | 56 | 35 | |
4909 | 194805 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 503 Beale St | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 6ft | 6015913.1436 | 2114020.02003 | 37.7855894765281 | -122.388677968825 | (37.7855894765281, -122.388677968825) | 6 | 2 | 9 | 28856 | 6 | |||
4929 | 246370 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 1999 Mission St | 7 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 0ft | 6006824.5951 | 2106962.8564 | 37.7657043092438 | -122.419620882946 | (37.7657043092438, -122.419620882946) | 8 | 4 | 7 | 28853 | 19 | |||
4949 | 205200 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 1523 Funston Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | Width 3ft | 5992104.38078 | 2105047.89219 | 37.7596061524293 | -122.47039497536 | (37.7596061524293, -122.47039497536) | 1 | 8 | 4 | 56 | 12 | |||
4978 | 132567 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 3332 Washington St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | Width 4ft | 5998810.95737 | 2115951.69903 | 37.7899306929035 | -122.447985446477 | (37.7899306929035, -122.447985446477) | 13 | 6 | 1 | 54 | 31 | |||
5114 | 144913 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 650 19th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 11/18/2019 12:00:00 AM | 0 | Width 3ft | 5990061.53557 | 2110928.15905 | 37.7756334418677 | -122.477889950472 | (37.7756334418677, -122.477889950472) | 11 | 6 | 2 | 55 | 26 | ||
5127 | 261795 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 555 Fulton St | 15 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 3X3 | 6005001.9506 | 2111591.9082 | 37.7783117284071 | -122.426254616894 | (37.7783117284071, -122.426254616894) | 7 | 9 | 11 | 28852 | 10 | ||||
5141 | 262445 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 99 Lyell St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | Width 3ft | 6003121 | 2094520 | 37.731329826937 | -122.43154242119 | (37.731329826937, -122.43154242119) | 9 | 7 | 5 | 28861 | 25 | ||||
5152 | 43235 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 1718 21st Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/12/2000 12:00:00 AM | 9 | Permit Number 43022 | 5989693.2293 | 2103631.2748 | 37.7555767947293 | -122.47863024953 | (37.7555767947293, -122.47863024953) | 1 | 8 | 3 | 56 | 35 | |
5166 | 246272 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 2097 Mission St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 0ft | 6006864.7942 | 2106195.7269 | 37.7636002158578 | -122.419427415102 | (37.7636002158578, -122.419427415102) | 8 | 4 | 7 | 28859 | 19 | |||
5172 | 12689 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 1335 Lake St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 20 | 4x4 | 5991312.41694 | 2114745.43882 | 37.7861871602686 | -122.473841436429 | (37.7861871602686, -122.473841436429) | 11 | 6 | 2 | 54 | 26 | |||
5197 | 132921 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 2307 Broadway | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 4ft | 6002461.11828 | 2117406.23377 | 37.7941324415101 | -122.435460324857 | (37.7941324415101, -122.435460324857) | 13 | 9 | 1 | 29490 | 27 | |||
5229 | 44454 | Permitted Site 7 | Pittosporum undulatum :: Victorian Box 36 | 95 Winding Way | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 03/23/2001 12:00:00 AM | Permit Number 43779 | 6002576.22413505 | 2086867.96270094 | 37.710288143695 | -122.432879348949 | (37.710288143695, -122.432879348949) | 9 | 7 | 6 | 28861 | 5 | ||
5235 | 235022 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 571 Douglass St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 01/10/1986 12:00:00 AM | 14 | Width 3ft | Permit Number 22679 | 6001215.76301 | 2102992.62687 | 37.7544854909317 | -122.438736056834 | (37.7544854909317, -122.438736056834) | 2 | 4 | 5 | 28862 | 22 | |
5277 | 97520 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 660 02nd Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 15 | 5x7 | 5995359.45919 | 2111051.62286 | 37.7762785007382 | -122.459572199401 | (37.7762785007382, -122.459572199401) | 11 | 6 | 2 | 54 | 11 | |||
5329 | 8038 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 555 Fulton St | 11 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 09/18/2015 12:00:00 AM | 12 | 3X3 | 6005189.4271 | 2111616.4778 | 37.7783897855843 | -122.425607814865 | (37.7783897855843, -122.425607814865) | 7 | 9 | 11 | 28852 | 10 | ||
5350 | 50689 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 1 Harrison St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 01/15/2004 12:00:00 AM | 6 | Permit Number 47259 | 6015816.80871 | 2115251.31458 | 37.7889649918797 | -122.389097265149 | (37.7889649918797, -122.389097265149) | 6 | 2 | 9 | 28855 | 6 | |
5363 | 139964 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 1675 EDDY ST | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11 | Width 0ft | 6002449.0973 | 2112621.5547 | 37.7809942516884 | -122.435159534337 | (37.7809942516884, -122.435159534337) | 15 | 5 | 11 | 29490 | 41 | |||
5391 | 132832 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 2118 Baker St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 18 | Width 4ft | 5999864.13017 | 2116351.87291 | 37.7910896096387 | -122.444370344534 | (37.7910896096387, -122.444370344534) | 13 | 6 | 1 | 29490 | 27 | |||
5394 | 43693 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 569 08th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/25/2000 12:00:00 AM | 6 | Permit Number 43337 | 5993435.90524 | 2111604.73258 | 37.7776863968417 | -122.466266453906 | (37.7776863968417, -122.466266453906) | 11 | 6 | 2 | 54 | 11 | |
5425 | 70160 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 500X 21st Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 10 | 5989407.07315 | 2111876.85603 | 37.7782002945858 | -122.480223321553 | (37.7782002945858, -122.480223321553) | 11 | 6 | 2 | 55 | 26 | |||
5450 | 36847 | Permitted Site 7 | Pittosporum undulatum :: Victorian Box 36 | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/26/1998 12:00:00 AM | Permit Number 39538 | ||||||||||||||
5457 | 138379 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 2000 Sutter St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 0ft | 6002976.0662 | 2114481.5252 | 37.7861311714309 | -122.433469446582 | (37.7861311714309, -122.433469446582) | 13 | 9 | 11 | 29490 | 27 | |||
5484 | 71815 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 151X Palm Ave | 5 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | DPW for City Agency | 10 | 3x3 | 5995888.68435 | 2113315.23973 | 37.7825242096287 | -122.45790532062 | (37.7825242096287, -122.45790532062) | 11 | 6 | 1 | 54 | 31 | ||
5524 | 13219 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 2233 Lombard St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 10/26/1993 12:00:00 AM | 12 | 3X3 | 6001693 | 2119338 | 37.7993929119919 | -122.438256546601 | (37.7993929119919, -122.438256546601) | 13 | 9 | 1 | 57 | 17 | ||
5525 | 3887 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 19 Castro St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 3X3 | 6002118.7656433 | 2108506.4769773 | 37.7696765127931 | -122.436007767762 | (37.7696765127931, -122.436007767762) | 15 | 5 | 5 | 29492 | 9 | |||
5539 | 20007 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 100 STAIRWAY46 | 27 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 6 | 2 | |||||||||||||
5595 | 138084 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 2031 Bush St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 0ft | 6003830.6412 | 2114896.4777 | 37.7873189738892 | -122.430542464211 | (37.7873189738892, -122.430542464211) | 13 | 9 | 11 | 29490 | 27 | |||
5618 | 137892 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 1700 Bush St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 0ft | 6005288.3833 | 2115155.435 | 37.7881124783388 | -122.425517415448 | (37.7881124783388, -122.425517415448) | 13 | 9 | 11 | 28858 | 27 | |||
5645 | 19799 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 100 STAIRWAY21 | 4 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 3 | 40ST | |||||||||||||
5723 | 185011 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 2701 Sunset Blvd | 37 | Sidewalk: Property side : Yard | Tree | Private 2 | 1 | Width 0ft | 5985034.3637 | 2096468.1875 | 37.7356373047826 | -122.494213879386 | (37.7356373047826, -122.494213879386) | 1 | 8 | 3 | 29491 | 35 | |||
5733 | 83114 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 2094 Oakdale Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 16 | 6012504.25253 | 2097415.87207 | 37.7398086567426 | -122.399305795219 | (37.7398086567426, -122.399305795219) | 10 | 3 | 8 | 58 | 1 | |||
5785 | 30357 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 676 Arkansas St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 08/15/1974 12:00:00 AM | 10 | Permit Number 14186 | 6012982.14128 | 2103938.33263 | 37.7577445593747 | -122.398110914609 | (37.7577445593747, -122.398110914609) | 10 | 3 | 8 | 28856 | 29 | ||
5801 | 68207 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 2048 Stockton St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/29/1993 12:00:00 AM | 10 | Permit Number 31989 | 6009891.7858 | 2121179.0457 | 37.8049108661303 | -122.410015779346 | (37.8049108661303, -122.410015779346) | 3 | 1 | 10 | 308 | 23 | |
5832 | 194684 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 1 Jack Balestreri Way | 28 | Front Yard : Yard | Tree | Private 2 | 9 | 6012406.88691 | 2104790.52602 | 37.7600524373766 | -122.400160243821 | (37.7600524373766, -122.400160243821) | 10 | 3 | 8 | 28856 | 29 | ||||
5843 | 144170 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 634 41st Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 01/15/2020 11:21:00 AM | 0 | Width 4ft | 5983217.90934 | 2111466.77005 | 37.7767127398322 | -122.501603204921 | (37.7767127398322, -122.501603204921) | 11 | 6 | 2 | 55 | 26 | ||
5913 | 194980 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 705 Natoma St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 2ft | 6009005.03299 | 2110836.03944 | 37.7764617471498 | -122.412352981411 | (37.7764617471498, -122.412352981411) | 8 | 2 | 9 | 28853 | 34 | |||
5927 | 211582 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 77 San Fernando Way | 2 | Sidewalk: Curb side : Yard | Tree | Private 2 | 23 | Width 8ft | 5992130.49269 | 2096095.02259 | 37.7350253849109 | -122.469652899757 | (37.7350253849109, -122.469652899757) | 1 | 8 | 4 | 59 | 40 | |||
5952 | 9359 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 248 Gold Mine Dr | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 03/11/2006 12:00:00 AM | 3 | 2X2 | 6001030.76503 | 2098329.85795 | 37.7416721140896 | -122.439041675227 | (37.7416721140896, -122.439041675227) | 2 | 7 | 5 | 63 | 7 | ||
5970 | 170466 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 90 Lyell St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 0 | Width 3ft | 6003125.15603 | 2094455.10756 | 37.7311518825422 | -122.431523422075 | (37.7311518825422, -122.431523422075) | 9 | 7 | 5 | 28861 | 25 | |||
6038 | 47402 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 566 07th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | FUF | 03/29/2018 12:00:00 AM | 3 | Permit Number 45313 | 5993788.46919 | 2111633.70566 | 37.7777862849163 | -122.465048929471 | (37.7777862849163, -122.465048929471) | 11 | 6 | 2 | 54 | 11 | |
6087 | 234303 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 3169 25th St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | Width 3ft | 6008574.07588 | 2101531.78106 | 37.7508902055256 | -122.413185706878 | (37.7508902055256, -122.413185706878) | 2 | 4 | 7 | 28859 | 19 | |||
6096 | 71050 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 165 Elmira St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 11 | 6011229.446 | 2095779.16104 | 37.7352434641973 | -122.403598436523 | (37.7352434641973, -122.403598436523) | 10 | 3 | 8 | 58 | 1 | |||
6118 | 147477 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 761 20th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 11/18/2019 12:00:00 AM | 0 | Width 4ft | 5989733.56986 | 2110175.87682 | 37.7735488421456 | -122.478969414809 | (37.7735488421456, -122.478969414809) | 11 | 6 | 2 | 55 | 26 | ||
6131 | 211756 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 78 Wawona St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 19 | Width 3ft | 5993077.54364 | 2098613.05866 | 37.7419939715557 | -122.466561599837 | (37.7419939715557, -122.466561599837) | 1 | 8 | 4 | 59 | 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) );