trees
7,157 rows where qSpecies_id = 36 sorted by Police Districts
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) |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 30348 | 133110 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 1215 Greenwich St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 3ft | 6006948.72818 | 2119783.68298 | 37.8009141652131 | -122.420101485307 | (37.8009141652131, -122.420101485307) | 5 | 1 | 1 | 28858 | 32 | |||
| 30450 | 133202 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 641 Davis St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 4ft | 6013101.60257 | 2118824.28726 | 37.7986246432807 | -122.398742426627 | (37.7986246432807, -122.398742426627) | 3 | 1 | 10 | 28860 | 6 | |||
| 30631 | 249900 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 300 Greenwich St | 1 | Front Yard : Yard | Tree | Private 2 | 6 | Width 0ft | 6011328.50093 | 2120408.94667 | 37.8028767818039 | -122.404989587011 | (37.8028767818039, -122.404989587011) | 3 | 1 | 10 | 308 | 23 | |||
| 31351 | 133197 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 556 Pine St | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 41 | Width 5ft | 6011311.53857 | 2116342.47556 | 37.7917102875417 | -122.404761831889 | (37.7917102875417, -122.404761831889) | 5 | 1 | 10 | 28857 | 6 | |||
| 31734 | 133116 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 1070 Lombard St | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 14 | 6007279.74173 | 2120227.04139 | 37.8021501601702 | -122.418987499588 | (37.8021501601702, -122.418987499588) | 5 | 1 | 1 | 28858 | 32 | ||||
| 33347 | 133222 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 600 Front St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 3ft | 6012881.09232 | 2118314.54186 | 37.7972127157502 | -122.399469660721 | (37.7972127157502, -122.399469660721) | 3 | 1 | 10 | 28860 | 6 | |||
| 35088 | 133241 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 221 Jackson St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 3ft | 6012632.9434 | 2118159.56205 | 37.7967733438808 | -122.400317432707 | (37.7967733438808, -122.400317432707) | 3 | 1 | 10 | 28860 | 6 | |||
| 35547 | 133149 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 240 Vallejo St | 4 | Sidewalk: Property side : Yard | Tree | Private 2 | 26 | Width 10ft | 6012302.10484 | 2119179.32915 | 37.7995549253743 | -122.401533924955 | (37.7995549253743, -122.401533924955) | 3 | 1 | 10 | 28860 | 6 | |||
| 35781 | 256056 | Undocumented 4 | Pittosporum undulatum :: Victorian Box 36 | 418 Lombard St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6010297 | 2120665 | 37.8035221265997 | -122.408577200527 | (37.8035221265997, -122.408577200527) | 3 | 1 | 10 | 308 | 23 | ||||
| 35796 | 133246 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 221 Jackson St | 7 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | Width 3ft | 6012718.97909 | 2118170.38949 | 37.7968078706334 | -122.400020488264 | (37.7968078706334, -122.400020488264) | 3 | 1 | 10 | 28860 | 6 | |||
| 35809 | 133192 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 1306x Montgomery St | 41 | Median : Yard | Tree | DPW 1 | 2 | Width 8ft | 6011420.83782 | 2120184.50099 | 37.8022656699768 | -122.404654242423 | (37.8022656699768, -122.404654242423) | 3 | 1 | 10 | 308 | 23 | |||
| 36066 | 133128 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 2008 Leavenworth St | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 13 | Width 3ft | 6007718.7343 | 2119354.17071 | 37.7997781865696 | -122.417406475237 | (37.7997781865696, -122.417406475237) | 5 | 1 | 1 | 308 | 32 | |||
| 36190 | 133270 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 55 Jackson St | 7 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 3ft | 6013381 | 2118288 | 37.7971676890736 | -122.397737980255 | (37.7971676890736, -122.397737980255) | 3 | 1 | 10 | 28860 | 6 | |||
| 36735 | 142914 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 1365x Kearny St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11 | Width 0ft | 6010980 | 2119621 | 37.8006937860332 | -122.406140040303 | (37.8006937860332, -122.406140040303) | 3 | 1 | 10 | 308 | 23 | |||
| 37070 | 133147 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 240 Vallejo St | 2 | Sidewalk: Property side : Yard | Tree | Private 2 | 14 | Width 8ft | 6012329.88439 | 2119185.49639 | 37.7995734091372 | -122.401438230791 | (37.7995734091372, -122.401438230791) | 3 | 1 | 10 | 28860 | 6 | |||
| 37276 | 133205 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 641 Davis St | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 4ft | 6013109.32213 | 2118763.8423 | 37.7984591059577 | -122.398711470177 | (37.7984591059577, -122.398711470177) | 3 | 1 | 10 | 28860 | 6 | |||
| 38822 | 61254 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 2048 Leavenworth St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/23/1983 12:00:00 AM | 12 | Permit Number 21135 | 6007704.81642 | 2119446.66907 | 37.8000313807916 | -122.417461195393 | (37.8000313807916, -122.417461195393) | 5 | 1 | 1 | 308 | 32 | |
| 39334 | 133209 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 641 Davis St | 10 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 4ft | 6013123.8854 | 2118671.56036 | 37.798206533163 | -122.398654597049 | (37.798206533163, -122.398654597049) | 3 | 1 | 10 | 28860 | 6 | |||
| 39397 | 99695 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 1550X Washington St | 6 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | DPW for City Agency | 10 | 3x3 | 6007274.7 | 2117123.2 | 37.7936275055362 | -122.418784695641 | (37.7936275055362, -122.418784695641) | 5 | 1 | 10 | 28858 | 32 | ||
| 39843 | 30454 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 381 Union St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/11/1956 12:00:00 AM | 8 | 3x3 | Permit Number 103 | 6011107.82741 | 2119661.98766 | 37.8008134771171 | -122.405700591027 | (37.8008134771171, -122.405700591027) | 3 | 1 | 10 | 308 | 23 | |
| 40680 | 133146 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 240 Vallejo St | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 20 | Width 10ft | 6012341.47571 | 2119176.88522 | 37.7995504116737 | -122.401397514901 | (37.7995504116737, -122.401397514901) | 3 | 1 | 10 | 28860 | 6 | |||
| 41455 | 109491 | Undocumented 4 | Pittosporum undulatum :: Victorian Box 36 | 1315 PINE ST | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6007628 | 2115744 | 37.789860448493 | -122.417464454457 | (37.789860448493, -122.417464454457) | 13 | 1 | 10 | 28858 | 21 | ||||
| 41926 | 133154 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 327 Green St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | Width 2ft | 6011389.04885 | 2119350.52508 | 37.7999739986567 | -122.404705502862 | (37.7999739986567, -122.404705502862) | 3 | 1 | 10 | 308 | 23 | |||
| 41928 | 133190 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 165 Francisco St | 13 | Front Yard : Yard | Tree | Private 2 | 3 | 6010565.46337 | 2121315.97137 | 37.8053245646485 | -122.407694093918 | (37.8053245646485, -122.407694093918) | 3 | 1 | 10 | 308 | 23 | ||||
| 42615 | 49408 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 600@ JACKSON Front St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 04/07/2006 12:00:00 AM | 14 | Permit Number 48770 | 6012890.23955 | 2118257.96713 | 37.7970578848771 | -122.399434034968 | (37.7970578848771, -122.399434034968) | 3 | 1 | 10 | 28860 | 6 | ||
| 43182 | 114013 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 735 Mason St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 16 | 3x3 | 6009613.23311 | 2115932.73849 | 37.7904901791164 | -122.410609035893 | (37.7904901791164, -122.410609035893) | 5 | 1 | 10 | 28857 | 21 | |||
| 43714 | 30460 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 470 Union St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/11/1956 12:00:00 AM | 19 | 4x4 | Permit Number 109 | 6010655.6465 | 2119643.9329 | 37.8007386066666 | -122.407264060286 | (37.8007386066666, -122.407264060286) | 3 | 1 | 10 | 308 | 23 | |
| 45111 | 133136 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 2442 Leavenworth St | 2 | Sidewalk: Property side : Yard | Tree | Private 2 | 8 | Width 3ft | 6007527.3131 | 2120803.9539 | 37.8037481538192 | -122.418171706579 | (37.8037481538192, -122.418171706579) | 5 | 1 | 1 | 308 | 32 | |||
| 46320 | 120616 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 2 North Point St | 10 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | 3x3 | 6010384.51701 | 2122042.28091 | 37.8073086993106 | -122.408371546927 | (37.8073086993106, -122.408371546927) | 3 | 1 | 10 | 308 | 23 | |||
| 46604 | 133039 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 1344 Pacific Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 3ft | 6007678.33721 | 2117843.0195 | 37.7956266695955 | -122.417439110733 | (37.7956266695955, -122.417439110733) | 5 | 1 | 10 | 28858 | 32 | |||
| 46865 | 114014 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 735 Mason St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 16 | 3x3 | 6009612.42047 | 2115916.38769 | 37.7904452382139 | -122.410610692447 | (37.7904452382139, -122.410610692447) | 5 | 1 | 10 | 28857 | 21 | |||
| 47568 | 133239 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 640 Front St | 10 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 3ft | 6012811.08125 | 2118812.56774 | 37.7985762732441 | -122.399746905493 | (37.7985762732441, -122.399746905493) | 3 | 1 | 10 | 28860 | 6 | |||
| 47784 | 98579 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 301X Francisco St | 17 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | DPW for City Agency | 3x3 | 6009861.3 | 2121227.6 | 37.8050424754696 | -122.410124709263 | (37.8050424754696, -122.410124709263) | 3 | 1 | 10 | 308 | 23 | |||
| 47895 | 133234 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 640 Front St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 3ft | 6012833.9893 | 2118645.15579 | 37.7981178770875 | -122.399655875238 | (37.7981178770875, -122.399655875238) | 3 | 1 | 10 | 28860 | 6 | |||
| 48126 | 108611 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 2025x Taylor St | 3 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | DPW for City Agency | 1 | 3x3 | 6008581.83386 | 2119799.52206 | 37.8010495338737 | -122.414451351572 | (37.8010495338737, -122.414451351572) | 5 | 1 | 10 | 308 | 32 | ||
| 48264 | 110607 | Undocumented 4 | Pittosporum undulatum :: Victorian Box 36 | 1181 GREEN ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4x4 | 6007369 | 2118756 | 37.7981160762917 | -122.418574247636 | (37.7981160762917, -122.418574247636) | 5 | 1 | 10 | 28858 | 32 | ||||
| 49150 | 100970 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 450X Chestnut St | 2 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | DPW | 9 | Permit Number 37341 | 6009657.9659 | 2120896.9693 | 37.8041232469329 | -122.410805008122 | (37.8041232469329, -122.410805008122) | 3 | 1 | 10 | 308 | 23 | ||
| 49197 | 133184 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 165 Francisco St | 5 | Front Yard : Yard | Tree | Private 2 | 26 | 6010514.4999 | 2121309.14638 | 37.8053029719104 | -122.407869978821 | (37.8053029719104, -122.407869978821) | 3 | 1 | 10 | 308 | 23 | ||||
| 49260 | 133174 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 1900 The Embarcadero | 10 | Sidewalk: Curb side : Pot | Tree | Private 2 | 8 | Width 5ft | 6010559.67042 | 2122087.00358 | 37.8074413034386 | -122.407768542507 | (37.8074413034386, -122.407768542507) | 3 | 1 | 10 | 308 | 23 | |||
| 49261 | 97810 | Permitted Site 7 | Pittosporum undulatum :: Victorian Box 36 | 901 Pine St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | Permit Number 33299 | 6009614 | 2116053 | 37.7908204311206 | -122.410614878669 | (37.7908204311206, -122.410614878669) | 5 | 1 | 10 | 28857 | 21 | |||
| 49856 | 133027 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 927 Pine St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 15 | Width 4ft | 6009562.17853 | 2116043.8748 | 37.7907924700417 | -122.410793534503 | (37.7907924700417, -122.410793534503) | 5 | 1 | 10 | 28857 | 21 | |||
| 51185 | 133025 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 1245 Pine St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 4ft | 6007960.75024 | 2115818.08149 | 37.7900825748942 | -122.416318415167 | (37.7900825748942, -122.416318415167) | 13 | 1 | 10 | 28858 | 21 | |||
| 51831 | 133075 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 899 North Point St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 3ft | 6006495.56154 | 2121453.88194 | 37.8054745625741 | -122.421788338267 | (37.8054745625741, -122.421788338267) | 5 | 1 | 1 | 28858 | 32 | |||
| 52545 | 133123 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 2008 Leavenworth St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | Width 3ft | 6007731.73397 | 2119272.47289 | 37.7995545962274 | -122.417355698615 | (37.7995545962274, -122.417355698615) | 5 | 1 | 1 | 308 | 32 | |||
| 53840 | 133138 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 2801 Leavenworth St | 8 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11 | Width 4ft | 6007294.5755 | 2122084.57406 | 37.8072513081645 | -122.419067998799 | (37.8072513081645, -122.419067998799) | 5 | 1 | 1 | 308 | 32 | |||
| 54247 | 37508 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 1055 Bush St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/22/1998 12:00:00 AM | 8 | Permit Number 39967 | 6008450.33204 | 2115534.6033 | 37.7893317309212 | -122.414604427856 | (37.7893317309212, -122.414604427856) | 5 | 1 | 10 | 28858 | 21 | ||
| 55266 | 142521 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 301 FRANCISCO ST | 4 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | 05/04/2013 12:00:00 AM | 0 | Width 0ft | 6009485.2617 | 2121177.5361 | 37.8048839283261 | -122.411422499274 | (37.8048839283261, -122.411422499274) | 3 | 1 | 10 | 308 | 23 | ||
| 55274 | 97809 | Permitted Site 7 | Pittosporum undulatum :: Victorian Box 36 | 901 Pine St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | Permit Number 33299 | 6009614 | 2116053 | 37.7908204311206 | -122.410614878669 | (37.7908204311206, -122.410614878669) | 5 | 1 | 10 | 28857 | 21 | ||||
| 55534 | 133046 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 1502 Washington St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 18 | Width 3ft | 6007263.8716 | 2117119.90367 | 37.793617844941 | -122.418821929009 | (37.793617844941, -122.418821929009) | 5 | 1 | 10 | 28858 | 32 | |||
| 56154 | 133107 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 1108 Green St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 3ft | 6007687.80875 | 2118893.29716 | 37.7985110031479 | -122.417480808716 | (37.7985110031479, -122.417480808716) | 5 | 1 | 10 | 28858 | 32 | |||
| 56539 | 133043 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 1502 Washington St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 20 | Width 3ft | 6007362.41685 | 2117134.32155 | 37.7936629810001 | -122.418481976261 | (37.7936629810001, -122.418481976261) | 5 | 1 | 10 | 28858 | 32 | |||
| 56834 | 133151 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 240 Vallejo St | 8 | Sidewalk: Curb side : Yard | Tree | Private 2 | 11 | Width 10ft | 6012242.89918 | 2119169.29739 | 37.7995240768369 | -122.401738093564 | (37.7995240768369, -122.401738093564) | 3 | 1 | 10 | 28860 | 6 | |||
| 57433 | 101617 | Undocumented 4 | Pittosporum undulatum :: Victorian Box 36 | 896X Hyde St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6007773.9 | 2115454.2 | 37.7890729368167 | -122.416939111253 | (37.7890729368167, -122.416939111253) | 13 | 1 | 10 | 28858 | 21 | ||||
| 57610 | 249912 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 356 Greenwich St | 1 | Front Yard : Yard | Tree | Private 2 | 12 | Width 0ft | 6011242.80215 | 2120418.17004 | 37.8028973160279 | -122.405286800351 | (37.8028973160279, -122.405286800351) | 3 | 1 | 10 | 308 | 23 | |||
| 57832 | 120615 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 2 North Point St | 9 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | 3x3 | 6010397.30052 | 2122043.98866 | 37.8073141042181 | -122.408327427091 | (37.8073141042181, -122.408327427091) | 3 | 1 | 10 | 308 | 23 | |||
| 57837 | 133247 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 221 Jackson St | 8 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 3ft | 6012741.18454 | 2118172.50482 | 37.7968149168371 | -122.399943800387 | (37.7968149168371, -122.399943800387) | 3 | 1 | 10 | 28860 | 6 | |||
| 57893 | 13018 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 418 Lombard St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 80 | 4x4 | 6010295.17865 | 2120692.75204 | 37.8035982248351 | -122.408585462293 | (37.8035982248351, -122.408585462293) | 3 | 1 | 10 | 308 | 23 | |||
| 57987 | 142609 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 700 CHESTNUT ST | 9 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | Width 0ft | 6008187.3399 | 2120697.5762 | 37.8034931957384 | -122.415880103282 | (37.8034931957384, -122.415880103282) | 5 | 1 | 10 | 308 | 32 | |||
| 58468 | 100975 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 450X Chestnut St | 7 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | DPW | 11 | Permit Number 37341 | 6009580.8633 | 2120886.4184 | 37.8040899533369 | -122.411071082632 | (37.8040899533369, -122.411071082632) | 3 | 1 | 10 | 308 | 23 | ||
| 59026 | 133156 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 99 North Point St | 17 | Sidewalk: Property side : Yard | Tree | Private 2 | 4 | Width 4ft | 6010460.75882 | 2121992.28603 | 37.8071756949569 | -122.408104165883 | (37.8071756949569, -122.408104165883) | 3 | 1 | 10 | 308 | 23 | |||
| 59763 | 64392 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 1201 Greenwich St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 04/28/1988 12:00:00 AM | 5 | Permit Number 25234 | 6006983.90328 | 2119787.2735 | 37.8009260056774 | -122.419980019268 | (37.8009260056774, -122.419980019268) | 5 | 1 | 1 | 28858 | 32 | ||
| 59806 | 133014 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 755 Mason St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 13 | Width 4ft | 6009608.08507 | 2115954.13708 | 37.7905486458447 | -122.41062835963 | (37.7905486458447, -122.41062835963) | 5 | 1 | 10 | 28857 | 21 | |||
| 59862 | 120620 | Undocumented 4 | Pittosporum undulatum :: Victorian Box 36 | 2 North Point St | 14 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6010405 | 2122056 | 37.8073475155142 | -122.408301628949 | (37.8073475155142, -122.408301628949) | 3 | 1 | 10 | 308 | 23 | ||||
| 59867 | 133233 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 640 Front St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 3ft | 6012834.56077 | 2118629.38176 | 37.7980745972289 | -122.399652789655 | (37.7980745972289, -122.399652789655) | 3 | 1 | 10 | 28860 | 6 | |||
| 60217 | 133220 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 601 Davis St | 11 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 3ft | 6013171.07136 | 2118300.37438 | 37.7971899736876 | -122.398465259167 | (37.7971899736876, -122.398465259167) | 3 | 1 | 10 | 28860 | 6 | |||
| 60346 | 143196 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 3 Midway St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | Width 0ft | 6010083.3642 | 2121319.2771 | 37.8053066422228 | -122.409362700866 | (37.8053066422228, -122.409362700866) | 3 | 1 | 10 | 308 | 23 | |||
| 61136 | 101619 | Undocumented 4 | Pittosporum undulatum :: Victorian Box 36 | 896X Hyde St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/01/2013 12:00:00 AM | 7 | 3x3 | Permit Number 771029 | 6007773.9 | 2115454.2 | 37.7890729368167 | -122.416939111253 | (37.7890729368167, -122.416939111253) | 13 | 1 | 10 | 28858 | 21 | |
| 61146 | 103459 | Permitted Site 7 | Pittosporum undulatum :: Victorian Box 36 | 1028 Sacramento St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/15/2013 12:00:00 AM | 3x3 | Permit Number 770176 | 6009851 | 2116823 | 37.7929479491773 | -122.409849243387 | (37.7929479491773, -122.409849243387) | 3 | 1 | 10 | 28857 | 21 | ||
| 61240 | 58805 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 1258 Union St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/10/1979 12:00:00 AM | 24 | Permit Number 18054 | 6006987.6862 | 2119143.01841 | 37.7991572568655 | -122.419921185614 | (37.7991572568655, -122.419921185614) | 5 | 1 | 1 | 28858 | 32 | ||
| 61897 | 142602 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 700 CHESTNUT ST | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 13 | Width 0ft | 6008358.423 | 2120721.6834 | 37.8035690046881 | -122.415289768557 | (37.8035690046881, -122.415289768557) | 5 | 1 | 10 | 308 | 32 | |||
| 62529 | 30463 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 453 Union St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/11/1956 12:00:00 AM | 16 | Permit Number 112 | 6010756.0784 | 2119614.4719 | 37.800663334257 | -122.406914444928 | (37.800663334257, -122.406914444928) | 3 | 1 | 10 | 308 | 23 | ||
| 62622 | 30446 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 357 Union St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/11/1956 12:00:00 AM | 12 | Permit Number 95 | 6011194.45133 | 2119670.62732 | 37.8008420431764 | -122.405401443236 | (37.8008420431764, -122.405401443236) | 3 | 1 | 10 | 308 | 23 | ||
| 64451 | 133166 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 1900 The Embarcadero | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 4ft | 6010237.48446 | 2122281.28865 | 37.8079567202001 | -122.40889726181 | (37.8079567202001, -122.40889726181) | 3 | 1 | 10 | 308 | 23 | |||
| 64530 | 133273 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 201 Jackson St | 10 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | Width 3ft | 6013474.68461 | 2118277.72169 | 37.7971446838233 | -122.397413084772 | (37.7971446838233, -122.397413084772) | 3 | 1 | 10 | 28860 | 6 | |||
| 64721 | 133013 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 755 Mason St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 14 | Width 4ft | 6009598.05506 | 2116002.17261 | 37.7906799774491 | -122.410666456692 | (37.7906799774491, -122.410666456692) | 5 | 1 | 10 | 28857 | 21 | |||
| 64936 | 133235 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 640 Front St | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 13 | Width 3ft | 6012824.99976 | 2118707.49944 | 37.7982885567276 | -122.399691361577 | (37.7982885567276, -122.399691361577) | 3 | 1 | 10 | 28860 | 6 | |||
| 65323 | 110958 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 940 Filbert St | 5 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | DPW for City Agency | 11 | 5x5 | 6008447.06762 | 2119689.6105 | 37.8007401724743 | -122.414909918573 | (37.8007401724743, -122.414909918573) | 5 | 1 | 10 | 308 | 32 | ||
| 65452 | 133224 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 600 Front St | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 15 | Width 3ft | 6012873.56074 | 2118359.49477 | 37.7973357259183 | -122.399498879669 | (37.7973357259183, -122.399498879669) | 3 | 1 | 10 | 28860 | 6 | |||
| 65553 | 142931 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 640 Vallejo St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 19 | Width 0ft | 6010349.4956 | 2118909.1613 | 37.7987039650956 | -122.408271621032 | (37.7987039650956, -122.408271621032) | 3 | 1 | 10 | 308 | 4 | |||
| 65617 | 133271 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 55 Jackson St | 8 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | Width 3ft | 6013381 | 2118288 | 37.7971676890736 | -122.397737980255 | (37.7971676890736, -122.397737980255) | 3 | 1 | 10 | 28860 | 6 | |||
| 65760 | 133125 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 2008 Leavenworth St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | Width 3ft | 6007725.45068 | 2119306.5078 | 37.7996476940491 | -122.417379854405 | (37.7996476940491, -122.417379854405) | 5 | 1 | 1 | 308 | 32 | |||
| 65856 | 133124 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 2008 Leavenworth St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | Width 3ft | 6007727.40108 | 2119294.23875 | 37.7996141160469 | -122.417372235343 | (37.7996141160469, -122.417372235343) | 5 | 1 | 1 | 308 | 32 | |||
| 66026 | 99833 | Undocumented 4 | Pittosporum undulatum :: Victorian Box 36 | 1610 Leavenworth St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3x | 6007914 | 2117933 | 37.7958869904292 | -122.416630050903 | (37.7958869904292, -122.416630050903) | 5 | 1 | 10 | 28858 | 21 | ||||
| 66053 | 249778 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 119 Pfeiffer St | 4 | Back Yard : Yard | Tree | Private 2 | 10 | Width 0ft | 6010409.80858 | 2121137.78544 | 37.804826595643 | -122.408220184708 | (37.804826595643, -122.408220184708) | 3 | 1 | 10 | 308 | 23 | |||
| 66131 | 99697 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 1451 Jackson St | 3 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | DPW for City Agency | 10 | 3x3 | 6007296.6569 | 2117418.12417 | 37.794438530258 | -122.418729647781 | (37.794438530258, -122.418729647781) | 5 | 1 | 10 | 28858 | 32 | ||
| 67244 | 33307 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 1200 Taylor St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 11/14/1996 12:00:00 AM | 13 | 3x3 | Permit Number 37455 | 6009003.23099 | 2117086.54707 | 37.793624037679 | -122.412801219702 | (37.793624037679, -122.412801219702) | 3 | 1 | 10 | 28857 | 21 |
| 68187 | 65490 | Permitted Site 7 | Pittosporum undulatum :: Victorian Box 36 | 1105 Bush St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 11/18/1995 12:00:00 AM | Permit Number 28374 | 6008199.50951886 | 2115504.50751693 | 37.7892350004146 | -122.415470115629 | (37.7892350004146, -122.415470115629) | 13 | 1 | 10 | 28858 | 21 | ||
| 68377 | 91356 | Permitted Site 7 | Pittosporum undulatum :: Victorian Box 36 | 2121 Leavenworth St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 02/24/2009 12:00:00 AM | 3x3 | Permit Number 52063 | 6007640 | 2119628 | 37.8005256228645 | -122.41769834526 | (37.8005256228645, -122.41769834526) | 5 | 1 | 1 | 28858 | 32 | ||
| 68430 | 133242 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 221 Jackson St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 3ft | 6012647.46242 | 2118162.71937 | 37.7967828227331 | -122.400267415105 | (37.7967828227331, -122.400267415105) | 3 | 1 | 10 | 28860 | 6 | |||
| 68486 | 133105 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 1133 Green St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 3ft | 6007644.36216 | 2118838.49422 | 37.7983580833172 | -122.417627261503 | (37.7983580833172, -122.417627261503) | 5 | 1 | 10 | 28858 | 32 | |||
| 68904 | 116005 | Undocumented 4 | Pittosporum undulatum :: Victorian Box 36 | 945 FRONT ST | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6012663 | 2119386 | 37.8001425245044 | -122.400299613665 | (37.8001425245044, -122.400299613665) | 3 | 1 | 10 | 28860 | 6 | ||||
| 69463 | 62980 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 1192 Vallejo St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 08/21/1986 12:00:00 AM | 12 | Permit Number 23370 | 6007860.63287 | 2118568.47777 | 37.7976288527366 | -122.416859756683 | (37.7976288527366, -122.416859756683) | 5 | 1 | 10 | 28858 | 21 | |
| 69868 | 142549 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 301 FRANCISCO ST | 11 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | 9 | Width 0ft | 6009666.9453 | 2121202.0395 | 37.8049613971858 | -122.410795492578 | (37.8049613971858, -122.410795492578) | 3 | 1 | 10 | 308 | 23 | |||
| 70628 | 99696 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 1451 Jackson St | 1 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | DPW for City Agency | 24 | 3x3 | 6007201.17567 | 2117403.71838 | 37.7943935992302 | -122.419059002888 | (37.7943935992302, -122.419059002888) | 5 | 1 | 10 | 28858 | 32 | ||
| 70862 | 115250 | Significant Tree 6 | Pittosporum undulatum :: Victorian Box 36 | 1404x Mason St | 1 | Front Yard : Yard | Tree | Private 2 | 01/20/2016 12:00:00 AM | 6009352.6 | 2118074.7 | 37.7963568672402 | -122.41166222086 | (37.7963568672402, -122.41166222086) | 3 | 1 | 10 | 308 | 4 | ||||
| 70985 | 133127 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 2008 Leavenworth St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 3ft | 6007720.23682 | 2119337.1161 | 37.7997314434221 | -122.417400066653 | (37.7997314434221, -122.417400066653) | 5 | 1 | 1 | 308 | 32 | |||
| 71444 | 133195 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 199 Union St | 3 | Sidewalk: Property side : Yard | Tree | Private 2 | 12 | 6012019.90845 | 2119791.75112 | 37.8012207378065 | -122.402553520547 | (37.8012207378065, -122.402553520547) | 3 | 1 | 10 | 28860 | 6 | ||||
| 71454 | 143191 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 2010 Grant Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 0ft | 6010332.7456 | 2121367.0379 | 37.805451750654 | -122.408503051838 | (37.805451750654, -122.408503051838) | 3 | 1 | 10 | 308 | 23 | |||
| 71456 | 133023 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 1245 Pine St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 4ft | 6007772.01188 | 2115791.41263 | 37.7899987338063 | -122.416969545929 | (37.7899987338063, -122.416969545929) | 13 | 1 | 10 | 28858 | 21 | |||
| 71472 | 101618 | Undocumented 4 | Pittosporum undulatum :: Victorian Box 36 | 896X Hyde St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | 3x3 | 6007773.9 | 2115454.2 | 37.7890729368167 | -122.416939111253 | (37.7890729368167, -122.416939111253) | 13 | 1 | 10 | 28858 | 21 |
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) );