trees
7,157 rows where qSpecies_id = 36 sorted by qLegalStatus_id
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) |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 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 | ||||
| 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 | ||
| 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 | ||
| 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 | |||
| 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 | |||
| 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 | |||
| 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 | |||
| 6220 | 70584 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 1801 Clement St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 7 | 5989883.84823 | 2113332.42802 | 37.7822245827165 | -122.478680478509 | (37.7822245827165, -122.478680478509) | 11 | 6 | 2 | 55 | 26 | |||
| 6283 | 71276 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 2133 Filbert St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 9 | 6002723.69312 | 2118844.90685 | 37.7980975740013 | -122.43465471125 | (37.7980975740013, -122.43465471125) | 13 | 9 | 1 | 57 | 17 | |||
| 6297 | 19148 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 49 Sanchez St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 3 | 3PL | 6003502.2481852 | 2108041.9364589 | 37.7684794961424 | -122.431189185107 | (37.7684794961424, -122.431189185107) | 7 | 9 | 5 | 28862 | 3 | |||
| 6299 | 75364 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 1335 Griffith St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 4 | 6017823.2525 | 2092467.3959 | 37.7265161261373 | -122.380570876773 | (37.7265161261373, -122.380570876773) | 10 | 3 | 8 | 58 | 1 | |||
| 6301 | 183034 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 2487 21st Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 0ft | 5989820.2795 | 2098485.3744 | 37.7414548799008 | -122.477814722118 | (37.7414548799008, -122.477814722118) | 1 | 8 | 3 | 29491 | 35 | |||
| 6309 | 235113 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 200X Prospect Ave | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 04/07/2020 09:12:00 AM | 3 | 5x5 | 6006667 | 2098452 | 37.7423265745703 | -122.419562086696 | (37.7423265745703, -122.419562086696) | 2 | 7 | 7 | 28859 | 2 | ||
| 6382 | 141249 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 30 JORDAN AVE | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 8 | Width 0ft | 5996221.8744 | 2114302.1595 | 37.7852531650895 | -122.456824036395 | (37.7852531650895, -122.456824036395) | 11 | 6 | 1 | 54 | 31 | |||
| 6403 | 74567 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 101 Laurel St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 6 | 5997978.88772 | 2116072.74607 | 37.7902154587146 | -122.450873051754 | (37.7902154587146, -122.450873051754) | 11 | 6 | 1 | 54 | 31 | |||
| 6444 | 262444 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 99 Lyell St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 02/09/2019 12:00:00 AM | 3 | Width 3ft | 6003121 | 2094520 | 37.731329826937 | -122.43154242119 | (37.731329826937, -122.43154242119) | 9 | 7 | 5 | 28861 | 25 | ||
| 6457 | 95973 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 6100 Geary Blvd | 2 | Median : | Tree | DPW 1 | 03/12/2011 12:00:00 AM | 1 | 5988036.984 | 2112655.97284 | 37.7802598227503 | -122.485020077411 | (37.7802598227503, -122.485020077411) | 11 | 6 | 2 | 55 | 26 | |||
| 6480 | 167318 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 95 Diamond St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 0 | 4x4 | 6001726.73498 | 2105330.83934 | 37.7609347127879 | -122.437136385953 | (37.7609347127879, -122.437136385953) | 15 | 4 | 5 | 28862 | 3 | |||
| 6501 | 194992 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 11 Dedman Ct | 7 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 14 | Width 3ft | 6016636.86174 | 2096261.76833 | 37.7368691785546 | -122.384936454554 | (37.7368691785546, -122.384936454554) | 10 | 3 | 8 | 58 | 1 | |||
| 6550 | 194776 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 1 Flora St | 1 | : | Tree | Private 2 | 3 | Width 3ft | 6013845.42665 | 2094215.08633 | 37.731094615529 | -122.394444484728 | (37.731094615529, -122.394444484728) | 10 | 3 | 8 | 58 | 1 | |||
| 6618 | 221977 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 49 Cumberland St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 17 | 3x3 | 6005317.72406 | 2104565.20901 | 37.7590359408747 | -122.424662252273 | (37.7590359408747, -122.424662252273) | 2 | 4 | 5 | 28859 | 19 | |||
| 6677 | 65895 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 126 Palm Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 05/31/1990 12:00:00 AM | 6 | Permit Number 28902 | 5995934.2793 | 2113524.40657 | 37.7831011454234 | -122.457762722955 | (37.7831011454234, -122.457762722955) | 11 | 6 | 1 | 54 | 31 | |
| 6692 | 170465 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 90 Lyell St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 0 | Width 3ft | 6003119.31929 | 2094475.31347 | 37.7312070325781 | -122.431545042679 | (37.7312070325781, -122.431545042679) | 9 | 7 | 5 | 28861 | 25 | |||
| 6721 | 73570 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 1500 Palou Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 8 | 6015400.1677 | 2094895.0317 | 37.7330479153498 | -122.389116887561 | (37.7330479153498, -122.389116887561) | 10 | 3 | 8 | 58 | 1 | |||
| 6723 | 9723 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 417X Fulton St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 6 | 3X3 | 6005743.31768 | 2111673.49547 | 37.7785776240411 | -122.423695752999 | (37.7785776240411, -122.423695752999) | 7 | 9 | 11 | 28852 | 10 | |||
| 6765 | 133006 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 300 Fulton St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 08/24/2012 12:00:00 AM | 2 | Width 4ft | 6006263.75126 | 2111819.37774 | 37.7790075453106 | -122.421905736669 | (37.7790075453106, -122.421905736669) | 7 | 9 | 11 | 28852 | 10 | ||
| 6779 | 60387 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 1436 Palou Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 10/26/1982 12:00:00 AM | 15 | Permit Number 19967 | 6015759.6141 | 2094635.0651 | 37.7323540184412 | -122.387856042206 | (37.7323540184412, -122.387856042206) | 10 | 3 | 8 | 58 | 1 | |
| 6789 | 61141 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 2139 Grove St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 09/28/1983 12:00:00 AM | 13 | Permit Number 20994 | 5997586.9682 | 2110213.9805 | 37.7741063846604 | -122.451806229049 | (37.7741063846604, -122.451806229049) | 15 | 5 | 11 | 29492 | 16 | |
| 6821 | 61205 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 156 Elmira St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 11/17/1983 12:00:00 AM | 11 | 3x3 | Permit Number 21073 | 6011187.02596 | 2095815.71279 | 37.7353414579279 | -122.403747670028 | (37.7353414579279, -122.403747670028) | 10 | 3 | 8 | 58 | 1 |
| 6948 | 20199 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 1300X Steiner St | 7 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 01/02/1991 12:00:00 AM | 12 | 3X3 | 6002784.1975 | 2112923.5771 | 37.7818425521761 | -122.434021853774 | (37.7818425521761, -122.434021853774) | 15 | 9 | 11 | 29490 | 41 | ||
| 6971 | 123476 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 500 Arguello Blvd | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11 | Width 4ft | 5995636.0481 | 2112739.28679 | 37.780928278722 | -122.458737616907 | (37.780928278722, -122.458737616907) | 11 | 6 | 2 | 54 | 16 | |||
| 7052 | 156880 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 3435 18th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 08/13/2020 12:00:00 AM | 3 | Width 2ft | 6006583.11261 | 2105511.47972 | 37.7617055639929 | -122.420353095823 | (37.7617055639929, -122.420353095823) | 2 | 4 | 7 | 28859 | 19 | ||
| 7082 | 30298 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 2751 Buchanan St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/24/1956 12:00:00 AM | 10 | Permit Number 141 | 6003515.61648 | 2117821.35346 | 37.7953320858627 | -122.43184130454 | (37.7953320858627, -122.43184130454) | 13 | 9 | 1 | 29490 | 27 |
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) );