trees
142,615 rows where qLegalStatus_id = 1 sorted by PlantType
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) |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 179 | 113995 | DPW Maintained 1 | :: 45 | 3221 Washington St | 1 | Sidewalk: Curb side : Cutout | Landscaping | Private 2 | 10/27/2015 12:00:00 AM | 39x3 | 5999265.7 | 2115942.6 | 37.789931692457 | -122.446411428366 | (37.789931692457, -122.446411428366) | 13 | 6 | 1 | 29490 | 31 | |||
| 388 | 109369 | DPW Maintained 1 | :: 45 | 2061 Hyde St | 1 | Sidewalk: Curb side : Cutout | Landscaping | Private 2 | FUF | 02/11/2015 12:00:00 AM | 3 | 5x6 | 6007159.6 | 2119443.7 | 37.7999925365465 | -122.419347645872 | (37.7999925365465, -122.419347645872) | 5 | 1 | 1 | 28858 | 32 | |
| 391 | 104857 | DPW Maintained 1 | :: 45 | 2555 46th Ave | Sidewalk: Curb side : Cutout | Landscaping | Private 2 | 5982069.8 | 2097707.6 | 37.7388664658919 | -122.504555139124 | (37.7388664658919, -122.504555139124) | 1 | 8 | 3 | 29491 | 35 | ||||||
| 1416 | 109762 | DPW Maintained 1 | :: 45 | 1801 Scott St | 1 | Sidewalk: Property side : Cutout | Landscaping | Private 2 | 1.5x6.5 | 6001511.7 | 2114646.3 | 37.7865004107291 | -122.438547564751 | (37.7865004107291, -122.438547564751) | 13 | 6 | 1 | 29490 | 27 | ||||
| 1437 | 109607 | DPW Maintained 1 | Shrub :: Shrub 66 | 775 Congo St | 1 | Front Yard : Yard | Landscaping | Private 2 | 6000381.8 | 2095947.7 | 37.7350943222142 | -122.441114705419 | (37.7350943222142, -122.441114705419) | 9 | 7 | 4 | 63 | 40 | |||||
| 2116 | 108701 | DPW Maintained 1 | Arbutus 'Marina' :: Hybrid Strawberry Tree 14 | 478 30th St | Sidewalk: Curb side : Cutout | Landscaping | Private 2 | FUF | 01/02/2015 12:00:00 AM | 3 | 3x3 | Permit Number 774626 | 6003507.49152 | 2098366.33094 | 37.7419128730633 | -122.43048058961 | (37.7419128730633, -122.43048058961) | 2 | 7 | 5 | 63 | 22 | |
| 2548 | 104858 | DPW Maintained 1 | :: 45 | 4205 24th St | Sidewalk: Property side : Cutout | Landscaping | Private 2 | 6001816 | 2101720.7 | 37.7510272133613 | -122.436569249202 | (37.7510272133613, -122.436569249202) | 2 | 4 | 5 | 28862 | 22 | ||||||
| 2857 | 99536 | DPW Maintained 1 | Tree(s) :: 17 | 188 Spear St | 4 | Sidewalk: Curb side : Cutout | Landscaping | Private 2 | 5x9 | 6014774.7 | 2116168.9 | 37.7914266467329 | -122.392767069159 | (37.7914266467329, -122.392767069159) | 12 | 2 | 9 | 28855 | 6 | ||||
| 3309 | 120871 | DPW Maintained 1 | Shrub :: Shrub 66 | 1387 08th Ave | 1 | Sidewalk: Curb side : Pot | Landscaping | Private 2 | 5993606 | 2106068 | 37.7624938100726 | -122.465275766733 | (37.7624938100726, -122.465275766733) | 1 | 8 | 11 | 56 | 12 | |||||
| 3740 | 102276 | DPW Maintained 1 | Tree(s) :: 17 | 279 Topaz Way | Back Yard : Yard | Landscaping | Private 2 | 6001205.6 | 2097796.6 | 37.7402178594385 | -122.438398959733 | (37.7402178594385, -122.438398959733) | 2 | 7 | 5 | 63 | 7 | ||||||
| 4037 | 260562 | DPW Maintained 1 | Potential Site :: Potential Site 48 | 260 Sagamore St | 10 | Sidewalk: Curb side : Cutout | Landscaping | Private 2 | 6x15 | 5994371.63973 | 2087473.84971 | 37.7114830007096 | -122.46127976636 | (37.7114830007096, -122.46127976636) | 9 | 8 | 6 | 28861 | 24 | ||||
| 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 | |||
| 4821 | 243633 | DPW Maintained 1 | Bambusa spp :: Bamboo Species 252 | 4757 25th St | 1 | Front Yard : Pot | Landscaping | Private 2 | 0 | Width 10ft | 6000099.67022 | 2101057.51685 | 37.749108590101 | -122.442456864219 | (37.749108590101, -122.442456864219) | 2 | 4 | 5 | 28862 | 22 | |||
| 5098 | 251531 | DPW Maintained 1 | :: 45 | 2100X 20th St | 2 | Sidewalk: Curb side : Cutout | Landscaping | Private 2 | 05/15/2017 12:00:00 AM | 3 | 4x11 | ||||||||||||
| 8171 | 260560 | DPW Maintained 1 | Potential Site :: Potential Site 48 | 260 Sagamore St | 8 | Sidewalk: Curb side : Cutout | Landscaping | Private 2 | 6x8 | 5994371.63973 | 2087473.84971 | 37.7114830007096 | -122.46127976636 | (37.7114830007096, -122.46127976636) | 9 | 8 | 6 | 28861 | 24 | ||||
| 8329 | 262123 | DPW Maintained 1 | Private shrub :: Private Shrub 284 | 270 Lansdale Ave | 1 | Back Yard : Yard | Landscaping | Private 2 | 5995063 | 2096577 | 37.7365178315951 | -122.459549144168 | (37.7365178315951, -122.459549144168) | 9 | 7 | 4 | 59 | 40 | |||||
| 10197 | 251293 | DPW Maintained 1 | :: 45 | 3789 Market St | 1 | Sidewalk: Property side : Cutout | Landscaping | Private 2 | 3x3 | 6000208 | 2102740 | 37.753734455764 | -122.442203020617 | (37.753734455764, -122.442203020617) | 2 | 4 | 5 | 63 | 38 | ||||
| 11972 | 99201 | DPW Maintained 1 | Tree(s) :: 17 | 4016 26th St | Sidewalk: Curb side : Cutout | Landscaping | DPW 1 | FUF | 04/12/2012 12:00:00 AM | 6x10.5 | Permit Number 768835 | 6003752.7 | 2100736.7 | 37.7484352450997 | -122.429801769855 | (37.7484352450997, -122.429801769855) | 2 | 4 | 5 | 28862 | 22 | ||
| 12997 | 258944 | DPW Maintained 1 | :: 45 | 190 Freelon St | 1 | Sidewalk: Curb side : Yard | Landscaping | DPW 1 | Width 2ft | 6013228 | 2111376 | 37.7781804260272 | -122.397782321929 | (37.7781804260272, -122.397782321929) | 6 | 2 | 9 | 28856 | 34 | ||||
| 13072 | 260558 | DPW Maintained 1 | Potential Site :: Potential Site 48 | 260 Sagamore St | 6 | Sidewalk: Curb side : Cutout | Landscaping | Private 2 | 6x6 | 5994371.63973 | 2087473.84971 | 37.7114830007096 | -122.46127976636 | (37.7114830007096, -122.46127976636) | 9 | 8 | 6 | 28861 | 24 | ||||
| 13953 | 116804 | DPW Maintained 1 | Juniperus chinensis :: Juniper 113 | 131 LAKESHORE DR | 1 | Median : Yard | Landscaping | DPW 1 | 10x100 | 5984782 | 2094243 | 37.7295127607338 | -122.494922366174 | (37.7295127607338, -122.494922366174) | 1 | 8 | 4 | 64 | 35 | ||||
| 14034 | 260614 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 50 Farnsworth Ln | 1 | Sidewalk: Property side : Yard | Landscaping | Private 2 | Width 6ft | 5996584.89502 | 2106441.40106 | 37.763690412698 | -122.454999901235 | (37.763690412698, -122.454999901235) | 15 | 5 | 11 | 29492 | 12 | ||||
| 14896 | 260559 | DPW Maintained 1 | Potential Site :: Potential Site 48 | 260 Sagamore St | 7 | Sidewalk: Curb side : Cutout | Landscaping | Private 2 | 6x12 | 5994371.63973 | 2087473.84971 | 37.7114830007096 | -122.46127976636 | (37.7114830007096, -122.46127976636) | 9 | 8 | 6 | 28861 | 24 | ||||
| 15400 | 112605 | DPW Maintained 1 | :: 45 | 1534 Hayes St | 1 | Sidewalk: Curb side : Cutout | Landscaping | Private 2 | 08/10/2015 12:00:00 AM | 5.6x12 | 6000465 | 2110329.2 | 37.7745871625182 | -122.441858914128 | (37.7745871625182, -122.441858914128) | 15 | 5 | 11 | 29492 | 16 | |||
| 15760 | 251532 | DPW Maintained 1 | :: 45 | 2100X 20th St | 4 | Sidewalk: Curb side : Cutout | Landscaping | Private 2 | 05/15/2017 12:00:00 AM | 3 | 4x11 | ||||||||||||
| 16094 | 206192 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 105 Lomita Ave | 1 | Sidewalk: Curb side : Cutout | Landscaping | Private 2 | 10 | Width 3ft | 5991391.3951 | 2104508.95832 | 37.7580851326494 | -122.472821514428 | (37.7580851326494, -122.472821514428) | 1 | 8 | 4 | 56 | 12 | |||
| 16139 | 253515 | DPW Maintained 1 | :: 45 | 559 24th Ave | 1 | Sidewalk: Curb side : Cutout | Landscaping | Private 2 | 09/15/2017 12:00:00 AM | 3 | 7x9.5 | 5988391 | 2112180 | 37.7789735494402 | -122.483760479148 | (37.7789735494402, -122.483760479148) | 11 | 6 | 2 | 55 | 26 | ||
| 17437 | 105043 | DPW Maintained 1 | :: 45 | 2660 Harrison St | 5 | Sidewalk: Property side : Cutout | Landscaping | Private 2 | 2x4 | 6008902 | 2102968 | 37.7548521445958 | -122.412153203197 | (37.7548521445958, -122.412153203197) | 2 | 4 | 7 | 28859 | 19 | ||||
| 18080 | 260563 | DPW Maintained 1 | Potential Site :: Potential Site 48 | 260 Sagamore St | 11 | Sidewalk: Curb side : Cutout | Landscaping | Private 2 | 6x10 | 5994371.63973 | 2087473.84971 | 37.7114830007096 | -122.46127976636 | (37.7114830007096, -122.46127976636) | 9 | 8 | 6 | 28861 | 24 | ||||
| 18457 | 107144 | DPW Maintained 1 | :: 45 | 360 Spear St | 1 | Sidewalk: Curb side : Cutout | Landscaping | Private 2 | 02/12/2020 12:00:00 AM | 3 | 6015708 | 2115219 | 37.7888702311939 | -122.38947147438 | (37.7888702311939, -122.38947147438) | 6 | 2 | 9 | 28855 | 6 | |||
| 18687 | 104158 | DPW Maintained 1 | :: 45 | 525X Church St | 6 | Sidewalk: Curb side : Cutout | Landscaping | SFUSD 4 | DPW | 5x20 | 6004243.11162 | 2105844.84418 | 37.7624887647889 | -122.428469979895 | (37.7624887647889, -122.428469979895) | 8 | 4 | 5 | 28862 | 3 | |||
| 18729 | 99529 | DPW Maintained 1 | Tree(s) :: 17 | 120 Howard St | 3 | Sidewalk: Curb side : Cutout | Landscaping | Private 2 | 4x9 | 6014737.1 | 2116083.2 | 37.7911892459774 | -122.392891167069 | (37.7911892459774, -122.392891167069) | 12 | 2 | 9 | 28855 | 6 | ||||
| 19343 | 260561 | DPW Maintained 1 | Potential Site :: Potential Site 48 | 260 Sagamore St | 9 | Sidewalk: Curb side : Cutout | Landscaping | Private 2 | 6x7 | 5994371.63973 | 2087473.84971 | 37.7114830007096 | -122.46127976636 | (37.7114830007096, -122.46127976636) | 9 | 8 | 6 | 28861 | 24 | ||||
| 22031 | 254088 | DPW Maintained 1 | :: 45 | 2520 Broadway | 1 | Sidewalk: Property side : Cutout | Landscaping | Private 2 | 12/22/2017 12:00:00 AM | 3 | 3.5x4.9 | 6001556.59478 | 2117325.5311 | 37.7938594403451 | -122.438584281493 | (37.7938594403451, -122.438584281493) | 13 | 9 | 1 | 57 | 27 | ||
| 22093 | 254089 | DPW Maintained 1 | :: 45 | 2520 Broadway | 2 | Sidewalk: Property side : Cutout | Landscaping | Private 2 | 12/22/2017 12:00:00 AM | 3 | 5x4.9 | 6001556.59478 | 2117325.5311 | 37.7938594403451 | -122.438584281493 | (37.7938594403451, -122.438584281493) | 13 | 9 | 1 | 57 | 27 | ||
| 22629 | 106932 | DPW Maintained 1 | Shrub :: Shrub 66 | 358 SHOTWELL ST | 1 | Sidewalk: Curb side : Cutout | Landscaping | Private 2 | 8x10 | 6007793.2 | 2105846.4 | 37.7626932925098 | -122.416191600332 | (37.7626932925098, -122.416191600332) | 8 | 4 | 7 | 28859 | 19 | ||||
| 24293 | 94928 | DPW Maintained 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 929#4 Broderick St | Sidewalk: Curb side : | Landscaping | Private 2 | 12/08/2010 12:00:00 AM | 3 | 26x6 | Permit Number 54775 | 6000937 | 2111843 | 37.7787705583514 | -122.440334763546 | (37.7787705583514, -122.440334763546) | 15 | 5 | 11 | 29490 | 41 | ||
| 25702 | 89015 | DPW Maintained 1 | Shrub :: Shrub 66 | 4437 20th St | Sidewalk: Curb side : Cutout | Landscaping | Private 2 | 09/30/2008 12:00:00 AM | 3x1 | Permit Number 51764 | 6001659 | 2104076 | 37.7574853780776 | -122.437280798466 | (37.7574853780776, -122.437280798466) | 2 | 4 | 5 | 28862 | 3 | |||
| 26240 | 115259 | DPW Maintained 1 | :: 45 | 2130 Jackson St | Sidewalk: Curb side : Cutout | Landscaping | Private 2 | 01/21/2016 12:00:00 AM | 6x12 | 6003918.8 | 2117004 | 37.7931106894063 | -122.430387878845 | (37.7931106894063, -122.430387878845) | 13 | 9 | 1 | 29490 | 27 | ||||
| 29040 | 89138 | DPW Maintained 1 | Tree(s) :: 17 | 3170 23rd St | Sidewalk: Curb side : Cutout | Landscaping | Private 2 | 10/06/2008 12:00:00 AM | Permit Number 770875 | 6007866.1 | 2102749.5 | 37.7541940143569 | -122.41572017373 | (37.7541940143569, -122.41572017373) | 2 | 4 | 7 | 28859 | 19 | ||||
| 29758 | 92776 | DPW Maintained 1 | Ligustrum japonicum :: Japanese Privet 232 | 2701 Pacific Ave | Sidewalk: Property side : Cutout | Landscaping | Private 2 | 10/15/2009 12:00:00 AM | Permit Number 52996 | 6001178.5 | 2116864.5 | 37.7925720539586 | -122.43985945141 | (37.7925720539586, -122.43985945141) | 13 | 6 | 1 | 29490 | 27 | ||||
| 31577 | 104151 | DPW Maintained 1 | :: 45 | 525X Church St | 1 | Sidewalk: Property side : Cutout | Landscaping | SFUSD 4 | DPW | 2x58 | 6004243.11162 | 2105844.84418 | 37.7624887647889 | -122.428469979895 | (37.7624887647889, -122.428469979895) | 8 | 4 | 5 | 28862 | 3 | |||
| 31704 | 111759 | DPW Maintained 1 | :: 45 | 1235 47th Ave | 2 | Sidewalk: Curb side : Yard | Landscaping | Private 2 | 06/23/2015 12:00:00 AM | 3 | 6x4 | 5981472.7 | 2106671.7 | 37.7634442160317 | -122.507284463143 | (37.7634442160317, -122.507284463143) | 1 | 8 | 3 | 56 | 35 | ||
| 32024 | 109349 | DPW Maintained 1 | Ficus Spp. :: 101 | 2505 Pacific Ave | 2 | Sidewalk: Property side : Cutout | Landscaping | Private 2 | 02/11/2015 12:00:00 AM | 3 | .5x1 | 6002092 | 2116990 | 37.7929686009801 | -122.43670770269 | (37.7929686009801, -122.43670770269) | 13 | 6 | 1 | 29490 | 27 | ||
| 33160 | 20136 | DPW Maintained 1 | Pyrus kawakamii :: Evergreen Pear 83 | 890 Steiner St | 1 | Sidewalk: Curb side : Cutout | Landscaping | Private 2 | 01/11/2011 12:00:00 AM | 3 | 8x4 | Permit Number 54087 | 6003007 | 2111306 | 37.777413731872 | -122.433135450293 | (37.777413731872, -122.433135450293) | 15 | 9 | 11 | 29492 | 10 | |
| 33206 | 245474 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 275 Grattan St | 1 | Sidewalk: Curb side : Cutout | Landscaping | Private 2 | 19 | Width 4ft | 5997377.53226 | 2106405.56262 | 37.7636374489232 | -122.452255843041 | (37.7636374489232, -122.452255843041) | 15 | 5 | 11 | 29492 | 9 | |||
| 33621 | 105147 | DPW Maintained 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 52 Mirabel Ave | Sidewalk: Curb side : Cutout | Landscaping | Private 2 | 12/26/2013 12:00:00 AM | 3X3 | Permit Number 771012 | 6007663.7 | 2099931.8 | 37.7464458666696 | -122.416220575031 | (37.7464458666696, -122.416220575031) | 2 | 7 | 7 | 28859 | 2 | |||
| 34209 | 107409 | DPW Maintained 1 | Shrub :: Shrub 66 | 125 VILLA TER | 1 | Sidewalk: Curb side : Cutout | Landscaping | Private 2 | 5999028.2 | 2104385.8 | 37.7581861070008 | -122.446401410764 | (37.7581861070008, -122.446401410764) | 2 | 5 | 5 | 28862 | 3 | |||||
| 35821 | 93164 | DPW Maintained 1 | Shrub :: Shrub 66 | 201 Upper Ter | 2 | Sidewalk: Property side : Cutout | Landscaping | Private 2 | 12/22/2009 12:00:00 AM | 1x2 | 5999670.5 | 2106448.3 | 37.7638858848202 | -122.444328283325 | (37.7638858848202, -122.444328283325) | 15 | 5 | 5 | 29492 | 3 | |||
| 36468 | 140265 | DPW Maintained 1 | Shrub :: Shrub 66 | 2100X Grove St | 3 | Sidewalk: Curb side : Cutout | Landscaping | Private 2 | 0 | Width 0ft | 5997671.17 | 2110272.3417 | 37.7742714515841 | -122.45151917218 | (37.7742714515841, -122.45151917218) | 15 | 5 | 2 | 29492 | 16 | |||
| 39983 | 83339 | DPW Maintained 1 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 149 | 2233 28th Ave | 1 | Sidewalk: Curb side : Cutout | Landscaping | Private 2 | 07/01/2009 12:00:00 AM | 3x3 | Permit Number 52332 | 5987590.2167451 | 2100087.03718588 | 37.7457229434205 | -122.485642930331 | (37.7457229434205, -122.485642930331) | 1 | 8 | 3 | 29491 | 35 | ||
| 43687 | 117610 | DPW Maintained 1 | Shrub :: Shrub 66 | 391 NEVADA ST | 1 | Unaccepted Street : Yard | Landscaping | Private 2 | 3x3 | 6008958 | 2096497 | 37.7370873514658 | -122.411502385785 | (37.7370873514658, -122.411502385785) | 10 | 7 | 7 | 28859 | 2 | ||||
| 44398 | 110615 | DPW Maintained 1 | Ginkgo biloba 'Autumn Gold' :: Ginkgo: Autumn Gold 3 | 200 McAllister St | 3 | Sidewalk: Curb side : Cutout | Landscaping | Private 2 | 12/31/2015 12:00:00 AM | 3 | 13.2x7.8 | Permit Number 773269 | 6008108 | 2112443 | 37.7808236983351 | -122.415569883338 | (37.7808236983351, -122.415569883338) | 7 | 10 | 9 | 28852 | 36 | |
| 45114 | 109367 | DPW Maintained 1 | :: 45 | 1205 Filbert St | 4 | Sidewalk: Curb side : Cutout | Landscaping | Private 2 | FUF | 02/11/2015 12:00:00 AM | 3 | 4.5x6.5 | 6007075.4 | 2119431.2 | 37.7999534721279 | -122.419638123127 | (37.7999534721279, -122.419638123127) | 5 | 1 | 1 | 28858 | 32 | |
| 46090 | 173847 | DPW Maintained 1 | :: 45 | 450 Toland St | 2 | Sidewalk: Curb side : Cutout | Landscaping | Private 2 | 01/27/2017 12:00:00 AM | 3 | 11.85x4 | 6012768.71675 | 2099101.44192 | 37.7444516111373 | -122.398509629682 | (37.7444516111373, -122.398509629682) | 10 | 3 | 8 | 58 | 1 | ||
| 46407 | 173850 | DPW Maintained 1 | :: 45 | 450 Toland St | 5 | Sidewalk: Curb side : Cutout | Landscaping | Private 2 | 01/27/2017 12:00:00 AM | 3 | 13.9x4 | 6012768.71675 | 2099101.44192 | 37.7444516111373 | -122.398509629682 | (37.7444516111373, -122.398509629682) | 10 | 3 | 8 | 58 | 1 | ||
| 47766 | 253517 | DPW Maintained 1 | :: 45 | 559 24th Ave | 2 | Sidewalk: Property side : Cutout | Landscaping | Private 2 | 09/15/2017 12:00:00 AM | 3 | 2x4.5 | 5988391 | 2112180 | 37.7789735494402 | -122.483760479148 | (37.7789735494402, -122.483760479148) | 11 | 6 | 2 | 55 | 26 | ||
| 47855 | 93115 | DPW Maintained 1 | Washingtonia robusta :: Mexican Fan Palm 72 | 397 San Jose Ave | 1 | Sidewalk: Curb side : | Landscaping | Private 2 | 02/02/2009 12:00:00 AM | 26x6 | Permit Number 53167 | 6006259.6 | 2100887.6 | 37.7489912240508 | -122.42114365927 | (37.7489912240508, -122.42114365927) | 2 | 4 | 5 | 28859 | 19 | ||
| 48163 | 82751 | DPW Maintained 1 | Pyrus calleryana 'Chanticleer' :: Ornamental Pear Tree 'Chanticleer' 39 | 52 Sheridan St | 1 | Sidewalk: Curb side : Cutout | Landscaping | Private 2 | 07/07/2009 12:00:00 AM | 3 | 3x3 | Permit Number 52446 | 6009256.89976445 | 2109417.42292722 | 37.772580689338 | -122.41138145626 | (37.772580689338, -122.41138145626) | 8 | 2 | 9 | 28853 | 34 | |
| 49164 | 17450 | DPW Maintained 1 | Ligustrum ovalifolium :: California privet 382 | 1967 Palou Ave | 4 | Sidewalk: Curb side : Cutout | Landscaping | DPW 1 | 42 | 3X3 | 6012966.10245 | 2096645.10936 | 37.7377180333685 | -122.397654855789 | (37.7377180333685, -122.397654855789) | 10 | 3 | 8 | 58 | 1 | |||
| 51851 | 227519 | DPW Maintained 1 | Ligustrum ovalifolium :: California privet 382 | 375 Alabama St | 1 | : | Landscaping | Private 2 | 8 | Width 3ft | 6008967.54586 | 2106408.18704 | 37.7643017925286 | -122.412169648322 | (37.7643017925286, -122.412169648322) | 8 | 4 | 7 | 28859 | 19 | |||
| 54600 | 82096 | DPW Maintained 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 1363 Francisco St | 1 | Sidewalk: Curb side : Cutout | Landscaping | Private 2 | 07/01/2009 12:00:00 AM | 3x3 | Permit Number 52338 | 6004802.97001971 | 2120513.88344233 | 37.8027979755173 | -122.427578771479 | (37.8027979755173, -122.427578771479) | 13 | 9 | 1 | 57 | 17 | ||
| 54811 | 109348 | DPW Maintained 1 | Ficus Spp. :: 101 | 2505 Pacific Ave | 1 | Sidewalk: Property side : Cutout | Landscaping | Private 2 | 02/11/2015 12:00:00 AM | 3 | .5x1 | 6002092 | 2116990 | 37.7929686009801 | -122.43670770269 | (37.7929686009801, -122.43670770269) | 13 | 6 | 1 | 29490 | 27 | ||
| 55462 | 94961 | DPW Maintained 1 | Tree(s) :: 17 | 3098 PACIFIC AVE | 1 | Sidewalk: Property side : Cutout | Landscaping | Private 2 | 10/25/2010 12:00:00 AM | 5999362 | 2116697 | 37.792008575714 | -122.446132526841 | (37.792008575714, -122.446132526841) | 13 | 6 | 1 | 29490 | 27 | ||||
| 55781 | 110246 | DPW Maintained 1 | :: 45 | 1706 28th Ave | 1 | Sidewalk: Curb side : Cutout | Landscaping | Private 2 | 04/01/2015 12:00:00 AM | 3 | 1.5x12 | 5987540.7 | 2103643.4 | 37.7554848751362 | -122.486075162345 | (37.7554848751362, -122.486075162345) | 1 | 8 | 3 | 56 | 35 | ||
| 56335 | 104565 | DPW Maintained 1 | Private shrub :: Private Shrub 284 | 18 FLOOD AVE | 1 | Front Yard : Yard | Landscaping | Private 2 | 6000327 | 2094154 | 37.7301661180838 | -122.441175517042 | (37.7301661180838, -122.441175517042) | 9 | 7 | 4 | 63 | 40 | |||||
| 58243 | 109770 | DPW Maintained 1 | Olea Majestic Beauty :: 183 | 9 Pomona St | 1 | Sidewalk: Curb side : Cutout | Landscaping | Private 2 | 12/29/2015 12:00:00 AM | 6x7 | Permit Number 774437 | 6014227.8 | 2094671.9 | 37.7323701819213 | -122.393154495945 | (37.7323701819213, -122.393154495945) | 10 | 3 | 8 | 58 | 1 | ||
| 59373 | 109769 | DPW Maintained 1 | :: 45 | 2502X Bush St | 2 | Sidewalk: Property side : Cutout | Landscaping | Private 2 | 1.5x12.75 | 6001313.62368 | 2114572.17699 | 37.7862856185892 | -122.439227543381 | (37.7862856185892, -122.439227543381) | 13 | 6 | 1 | 29490 | 27 | ||||
| 60245 | 108910 | DPW Maintained 1 | Agonis flexuosa :: Peppermint Willow 65 | 129 Ellert St | 1 | Sidewalk: Curb side : Cutout | Landscaping | Private 2 | FUF | 01/09/2015 12:00:00 AM | 3 | 3x3 | Permit Number 773054 | 6007361.2 | 2097016.9 | 37.7384251864379 | -122.417060086005 | (37.7384251864379, -122.417060086005) | 2 | 7 | 7 | 28859 | 2 |
| 61259 | 221750 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 275 Grattan St | 2 | Sidewalk: Curb side : Cutout | Landscaping | Private 2 | 11 | Width 4ft | 5997409.41415 | 2106414.31665 | 37.7636633116224 | -122.452146205787 | (37.7636633116224, -122.452146205787) | 15 | 5 | 11 | 29492 | 9 | |||
| 64175 | 109535 | DPW Maintained 1 | :: 45 | 1234 Filbert St | 3 | Sidewalk: Property side : Cutout | Landscaping | Private 2 | FUF | 02/23/2015 12:00:00 AM | 3 | 1.5x2.4 | 6007007.9 | 2119506.8 | 37.8001572481983 | -122.419877066677 | (37.8001572481983, -122.419877066677) | 5 | 1 | 1 | 28858 | 32 | |
| 64619 | 253411 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 1321 Mission St | 3 | Sidewalk: Curb side : Cutout | Landscaping | Private 2 | 08/30/2017 12:00:00 AM | 3 | 4x12 | Permit Number 775218 | 6008256.52806819 | 2110680.03106396 | 37.7759913538039 | -122.414931236288 | (37.7759913538039, -122.414931236288) | 8 | 2 | 9 | 28853 | 34 | |
| 66039 | 109366 | DPW Maintained 1 | :: 45 | 1205 Filbert St | 3 | Sidewalk: Property side : Cutout | Landscaping | Private 2 | FUF | 02/11/2015 12:00:00 AM | 3 | 3.125x22 | 6007075.4 | 2119431.2 | 37.7999534721279 | -122.419638123127 | (37.7999534721279, -122.419638123127) | 5 | 1 | 1 | 28858 | 32 | |
| 67643 | 92611 | DPW Maintained 1 | Shrub :: Shrub 66 | 3856 23rd St | Sidewalk: Property side : Pot | Landscaping | Private 2 | 08/31/2009 12:00:00 AM | Permit Number 52924 | 6004067 | 2102488 | 37.7532616988935 | -122.428839761175 | (37.7532616988935, -122.428839761175) | 2 | 4 | 5 | 28862 | 22 | ||||
| 68093 | 106516 | DPW Maintained 1 | Tree(s) :: 17 | 366 Hill St | Sidewalk: Curb side : Cutout | Landscaping | Private 2 | 05/07/2014 12:00:00 AM | 3X3 | Permit Number 772751 | 6003996.2 | 2103381.7 | 37.7557115810688 | -122.42914832014 | (37.7557115810688, -122.42914832014) | 2 | 4 | 5 | 28862 | 22 | |||
| 69385 | 83007 | DPW Maintained 1 | Laurus x 'Saratoga' :: Hybrid Laurel 4 | 1058 De Haro St | 1 | Median : Cutout | Landscaping | Private 2 | 07/02/2009 12:00:00 AM | 3x3 | Permit Number 52381 | 6012170.46860809 | 2103464.70975517 | 37.7563988530014 | -122.400884755815 | (37.7563988530014, -122.400884755815) | 10 | 3 | 8 | 28856 | 29 | ||
| 70325 | 254123 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 2111 46th Ave | 1 | Sidewalk: Curb side : Cutout | Landscaping | Private 2 | 05/14/2019 12:00:00 AM | 3 | 3x15 | Permit Number 783274 | 5981986.1845 | 2100718.85597 | 37.747129621994 | -122.505067335608 | (37.747129621994, -122.505067335608) | 1 | 8 | 3 | 29491 | 35 | |
| 70329 | 16698 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 950X Noriega St | 2 | Median : Cutout | Landscaping | DPW 1 | 12 | 8 | 5991017.96771 | 2103156.31666 | 37.7543495107367 | -122.47401428524 | (37.7543495107367, -122.47401428524) | 1 | 8 | 4 | 56 | 12 | |||
| 70800 | 225282 | DPW Maintained 1 | Pittosporum crassifolium :: Karo Tree 95 | 101 Rivoli St | 2 | Sidewalk: Curb side : Cutout | Landscaping | Private 2 | 6 | Width 3ft | 5998123.1152 | 2105954.07554 | 37.762440462975 | -122.44964458054 | (37.762440462975, -122.44964458054) | 15 | 5 | 11 | 29492 | 9 | |||
| 71605 | 109344 | DPW Maintained 1 | :: 45 | 3211 Baker St | 3 | Sidewalk: Property side : Yard | Landscaping | Private 2 | 02/11/2015 12:00:00 AM | 3 | 4x13 | 5999315.1 | 2119860.5 | 37.8006920253414 | -122.446522498385 | (37.8006920253414, -122.446522498385) | 13 | 9 | 1 | 57 | 17 | ||
| 72279 | 103619 | DPW Maintained 1 | Tree(s) :: 17 | 1200 Monterey Blvd | 1 | Front Yard : Yard | Landscaping | Private 2 | 5994284.3 | 2094292 | 37.7301989768893 | -122.462075764747 | (37.7301989768893, -122.462075764747) | 9 | 8 | 4 | 59 | 40 | |||||
| 73650 | 99530 | DPW Maintained 1 | Tree(s) :: 17 | 120 Howard St | 4 | Sidewalk: Curb side : Cutout | Landscaping | Private 2 | 4x9 | 6014737.1 | 2116083.2 | 37.7911892459774 | -122.392891167069 | (37.7911892459774, -122.392891167069) | 12 | 2 | 9 | 28855 | 6 | ||||
| 74831 | 181347 | DPW Maintained 1 | Tree(s) :: 17 | 2500 Sunset Blvd | 69 | Sidewalk: Property side : Yard | Landscaping | Private 2 | 6 | Width 0ft | 5985144.6465 | 2098114.9716 | 37.7401653859663 | -122.493953920474 | (37.7401653859663, -122.493953920474) | 1 | 8 | 3 | 29491 | 35 | |||
| 75257 | 92778 | DPW Maintained 1 | Ligustrum japonicum :: Japanese Privet 232 | 2701 Pacific Ave | Sidewalk: Property side : Cutout | Landscaping | Private 2 | 10/15/2009 12:00:00 AM | Permit Number 52996 | 6001178.5 | 2116864.5 | 37.7925720539586 | -122.43985945141 | (37.7925720539586, -122.43985945141) | 13 | 6 | 1 | 29490 | 27 | ||||
| 76327 | 109486 | DPW Maintained 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 1314 POLK ST | 1 | Sidewalk: Curb side : Pot | Landscaping | DPW 1 | 01/23/2016 04:50:00 AM | 3 | 3x3 | 6006825.7 | 2115468.8 | 37.7890596427133 | -122.420220804515 | (37.7890596427133, -122.420220804515) | 13 | 9 | 10 | 28858 | 21 | ||
| 77045 | 109322 | DPW Maintained 1 | Private shrub :: Private Shrub 284 | 191 24TH AVE | 1 | Sidewalk: Curb side : Cutout | Landscaping | Private 2 | 3x3 | 5988309.1 | 2114757.6 | 37.7860461422813 | -122.484232887865 | (37.7860461422813, -122.484232887865) | 11 | 6 | 1 | 55 | 33 | ||||
| 77582 | 82889 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 1423 Francisco St | 1 | Sidewalk: Curb side : Cutout | Landscaping | Private 2 | 07/01/2009 12:00:00 AM | 3x3 | Permit Number 52339 | 6004509.13864627 | 2120473.3950975 | 37.8026701808582 | -122.42859269053 | (37.8026701808582, -122.42859269053) | 13 | 9 | 1 | 57 | 17 | ||
| 78434 | 104861 | DPW Maintained 1 | :: 45 | 3458A 18th St | Sidewalk: Property side : Cutout | Landscaping | Private 2 | 6006508 | 2105569.9 | 37.7618617394874 | -122.420617027809 | (37.7618617394874, -122.420617027809) | 8 | 4 | 7 | 28859 | 19 | ||||||
| 78553 | 109534 | DPW Maintained 1 | :: 45 | 1234 Filbert St | 2 | Sidewalk: Property side : Cutout | Landscaping | Private 2 | FUF | 02/23/2015 12:00:00 AM | 3 | 1.5x2.6 | 6007007.9 | 2119506.8 | 37.8001572481983 | -122.419877066677 | (37.8001572481983, -122.419877066677) | 5 | 1 | 1 | 28858 | 32 | |
| 79157 | 173848 | DPW Maintained 1 | :: 45 | 450 Toland St | 3 | Sidewalk: Curb side : Cutout | Landscaping | Private 2 | 01/27/2017 12:00:00 AM | 3 | 19.5x4 | 6012768.71675 | 2099101.44192 | 37.7444516111373 | -122.398509629682 | (37.7444516111373, -122.398509629682) | 10 | 3 | 8 | 58 | 1 | ||
| 79210 | 109345 | DPW Maintained 1 | :: 45 | 3211 Baker St | 4 | Sidewalk: Property side : Yard | Landscaping | Private 2 | 02/11/2015 12:00:00 AM | 3 | 8.75x13 | 5999315.1 | 2119860.5 | 37.8006920253414 | -122.446522498385 | (37.8006920253414, -122.446522498385) | 13 | 9 | 1 | 57 | 17 | ||
| 79291 | 104154 | DPW Maintained 1 | :: 45 | 525X Church St | 2 | Sidewalk: Curb side : Cutout | Landscaping | SFUSD 4 | DPW | 5x17 | 6004243.11162 | 2105844.84418 | 37.7624887647889 | -122.428469979895 | (37.7624887647889, -122.428469979895) | 8 | 4 | 5 | 28862 | 3 | |||
| 79912 | 254090 | DPW Maintained 1 | :: 45 | 2520 Broadway | 3 | Sidewalk: Property side : Cutout | Landscaping | Private 2 | 12/22/2017 12:00:00 AM | 3 | 1.75x4.9 | 6001556.59478 | 2117325.5311 | 37.7938594403451 | -122.438584281493 | (37.7938594403451, -122.438584281493) | 13 | 9 | 1 | 57 | 27 | ||
| 82433 | 109343 | DPW Maintained 1 | :: 45 | 3211 Baker St | 2 | Sidewalk: Property side : Yard | Landscaping | Private 2 | 02/11/2015 12:00:00 AM | 3 | 4x13 | 5999315.1 | 2119860.5 | 37.8006920253414 | -122.446522498385 | (37.8006920253414, -122.446522498385) | 13 | 9 | 1 | 57 | 17 | ||
| 85006 | 88654 | DPW Maintained 1 | Ginkgo biloba 'Autumn Sentinel' :: Autumn Sentinel Ginkgo 454 | 94 Danton St | Sidewalk: Property side : Cutout | Landscaping | Private 2 | 08/05/2008 12:00:00 AM | Permit Number 51634 | 6002844 | 2094598 | 37.7315282931893 | -122.432505629551 | (37.7315282931893, -122.432505629551) | 9 | 7 | 5 | 28861 | 25 | ||||
| 85170 | 110614 | DPW Maintained 1 | Ginkgo biloba 'Autumn Gold' :: Ginkgo: Autumn Gold 3 | 200 McAllister St | 2 | Sidewalk: Curb side : Cutout | Landscaping | Private 2 | 12/31/2015 12:00:00 AM | 3 | 21.4x7.8 | Permit Number 773269 | 6008108 | 2112443 | 37.7808236983351 | -122.415569883338 | (37.7808236983351, -122.415569883338) | 7 | 10 | 9 | 28852 | 36 | |
| 86616 | 99531 | DPW Maintained 1 | Tree(s) :: 17 | 120 Howard St | 5 | Sidewalk: Curb side : Cutout | Landscaping | Private 2 | 4x9 | 6014737.1 | 2116083.2 | 37.7911892459774 | -122.392891167069 | (37.7911892459774, -122.392891167069) | 12 | 2 | 9 | 28855 | 6 | ||||
| 88473 | 85294 | DPW Maintained 1 | Populus nigra 'Italica' :: Lombardy Poplar 59 | 2255 Mariposa St | Sidewalk: Property side : Cutout | Landscaping | Private 2 | 07/27/2007 12:00:00 AM | 2x50 | Permit Number 49675 | 6010752 | 2105977 | 37.7632178155038 | -122.405967315915 | (37.7632178155038, -122.405967315915) | 8 | 4 | 8 | 28859 | 19 | |||
| 88857 | 100242 | DPW Maintained 1 | Tree(s) :: 17 | 76 Linda St | Sidewalk: Curb side : Pot | Landscaping | Private 2 | 6005815 | 2105046 | 37.76038415245 | -122.422976606568 | (37.76038415245, -122.422976606568) | 2 | 4 | 5 | 28859 | 19 | ||||||
| 89615 | 106576 | DPW Maintained 1 | Private shrub :: Private Shrub 284 | 507 STEINER ST | 1 | Front Yard : Yard | Landscaping | Private 2 | 6003113.3 | 2110111.6 | 37.7741402349502 | -122.432682383122 | (37.7741402349502, -122.432682383122) | 15 | 5 | 11 | 29492 | 10 |
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) );