Data source: data.sfgov.org
This data as json, CSV (advanced)
qCareAssistant ✖
Link | rowid | TreeID | qLegalStatus | qSpecies | qAddress | SiteOrder | qSiteInfo | PlantType | qCaretaker | qCareAssistant | PlantDate ▼ | DBH | PlotSize | PermitNotes | XCoord | YCoord | Latitude | Longitude | Location |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
110484 | 110484 | 87389 | Permitted Site 1 | Acer palmatum :: Japanese Maple 175 | 201 Topeka Ave | 3 | Back Yard : Yard 13 | Tree 1 | Private 1 | 04/24/2008 12:00:00 AM | Permit Number 50366 | 6012955.9 | 2095077.8 | 37.7334139596128 | -122.39758023766399 | (37.7334139596128, -122.397580237664) | |||
114905 | 114905 | 87384 | Permitted Site 1 | Magnolia spp :: Magnolia 89 | 152 Pixley St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/24/2008 12:00:00 AM | 7 | 3x3 | Permit Number 50364 | 6002625.0 | 2119034.0 | 37.7986111712331 | -122.43500974871701 | (37.7986111712331, -122.435009748717) | |
117461 | 117461 | 90301 | DPW Maintained 3 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 4333 Balboa St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 04/24/2008 12:00:00 AM | 3 | 3x3 | 5982098.55132 | 2110964.4874299997 | 37.7752678105386 | -122.505438090136 | (37.7752678105386, -122.505438090136) | ||
118127 | 118127 | 90282 | DPW Maintained 3 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 4424 Balboa St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 04/24/2008 12:00:00 AM | 3 | 3x3 | 5981833.059330001 | 2111013.45744 | 37.7753866408778 | -122.506360103881 | (37.7753866408778, -122.506360103881) | ||
118655 | 118655 | 90283 | DPW Maintained 3 | Lagunaria patersonii :: Primrose Tree 48 | 4508 Balboa St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 04/24/2008 12:00:00 AM | 3 | 3x3 | 5981566.01243 | 2111001.7560900003 | 37.7753387866897 | -122.507282997083 | (37.7753387866897, -122.507282997083) | ||
118897 | 118897 | 90284 | DPW Maintained 3 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 4524 Balboa St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 04/24/2008 12:00:00 AM | 3 | 3x3 | 5981520.2298099995 | 2111001.39767 | 37.7753351058251 | -122.507441340394 | (37.7753351058251, -122.507441340394) | ||
119210 | 119210 | 90304 | DPW Maintained 3 | Quercus agrifolia :: Coast Live Oak 180 | 4231 Balboa St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 04/24/2008 12:00:00 AM | 3 | 3x3 | 5982423.814069999 | 2110977.5837 | 37.7753229044019 | -122.504313921326 | (37.7753229044019, -122.504313921326) | ||
119884 | 119884 | 90298 | DPW Maintained 3 | Quercus agrifolia :: Coast Live Oak 180 | 4527 Balboa St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | Cleary Bros. Landscape 8 | 04/24/2008 12:00:00 AM | 3 | 3x3 | 5981574.06475 | 2110953.226782 | 37.77520601375029 | -122.507251541607 | (37.7752060137503, -122.507251541607) | |
120709 | 120709 | 90295 | DPW Maintained 3 | Quercus agrifolia :: Coast Live Oak 180 | 4899X Balboa St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | Cleary Bros. Landscape 8 | 04/24/2008 12:00:00 AM | 3 | 3x3 | 5980415.19176 | 2110911.332666 | 37.775022659049704 | -122.51125715579398 | (37.7750226590497, -122.511257155794) | |
123534 | 123534 | 90281 | DPW Maintained 3 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 4400X Balboa St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 04/24/2008 12:00:00 AM | 3 | 3x3 | 5981875.06739 | 2111015.6850400004 | 37.7753952303043 | -122.506214955899 | (37.7753952303043, -122.506214955899) | ||
123768 | 123768 | 90279 | DPW Maintained 3 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 4338 Balboa St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 04/24/2008 12:00:00 AM | 3 | 3x3 | 5982078.08793 | 2111023.84587 | 37.77542958721521 | -122.505513277346 | (37.7754295872152, -122.505513277346) | ||
125110 | 125110 | 90275 | DPW Maintained 3 | Lagunaria patersonii :: Primrose Tree 48 | 4300X Balboa St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 04/24/2008 12:00:00 AM | 3 | 3x3 | 5982191.02218 | 2111027.01163 | 37.775444924896 | -122.50512285244801 | (37.775444924896, -122.505122852448) | ||
127425 | 127425 | 87390 | Permitted Site 1 | Eriobotrya deflexa :: Bronze Loquat 49 | 3318 Fillmore St | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/24/2008 12:00:00 AM | 3x3 | Permit Number 50367 | 6002344.5 | 2119563.8 | 37.8000499325498 | -122.43601829666099 | (37.8000499325498, -122.436018296661) | |||
129023 | 129023 | 90300 | DPW Maintained 3 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 4425 Balboa St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 04/24/2008 12:00:00 AM | 3 | 3x3 | 5981861.24257 | 2110957.0551 | 37.775233435802 | -122.50625842987199 | (37.775233435802, -122.506258429872) | ||
140241 | 140241 | 90306 | DPW Maintained 3 | Quercus agrifolia :: Coast Live Oak 180 | 4149X Balboa St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 04/24/2008 12:00:00 AM | 3 | 3x3 | 5982680.929880001 | 2110985.11147 | 37.7753586920926 | -122.50342507068399 | (37.7753586920926, -122.503425070684) | ||
141426 | 141426 | 90272 | DPW Maintained 3 | Quercus agrifolia :: Coast Live Oak 180 | 4122 Balboa St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 04/24/2008 12:00:00 AM | 3 | 3x3 | 5982765.5809 | 2111043.53002 | 37.77552406850371 | -122.503136574036 | (37.7755240685037, -122.503136574036) | ||
141899 | 141899 | 90288 | DPW Maintained 3 | Quercus agrifolia :: Coast Live Oak 180 | 4790X Balboa St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | Cleary Bros. Landscape 8 | 04/24/2008 12:00:00 AM | 3 | 3x3 | 5980763.025413 | 2110963.934321 | 37.7751876098256 | -122.51005785431002 | (37.7751876098256, -122.51005785431) | |
143887 | 143887 | 90271 | DPW Maintained 3 | Quercus agrifolia :: Coast Live Oak 180 | 4100X Balboa St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | Cleary Bros. Landscape 8 | 04/24/2008 12:00:00 AM | 3 | 3x3 | 5982889.660166 | 2111040.818849 | 37.7755239169344 | -122.502707160377 | (37.7755239169344, -122.502707160377) | |
183255 | 183255 | 83569 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 2579 27th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/24/2008 12:00:00 AM | 1 | 3x3 | Permit Number 50370 | 5987984.0904 | 2097769.4524 | 37.7393824087044 | -122.48411106317499 | (37.7393824087044, -122.484111063175) | |
101711 | 101711 | 91489 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 430 Hamilton St | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/24/2009 12:00:00 AM | 3x3 | Permit Number 52114 | 6009410.2 | 2092292.9 | 37.725569143547204 | -122.40964227476499 | (37.7255691435472, -122.409642274765) | |||
43848 | 43848 | 99190 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 1155@Greenwich Battery St | 3 | Unaccepted Street : Yard 14 | Tree 1 | Private 1 | 04/24/2012 12:00:00 AM | 13 | Park | Permit Number 768770 | 6012236.89935 | 2120056.2938 | 37.801959219714 | -122.401821238566 | (37.801959219714, -122.401821238566) | |
128771 | 128771 | 102810 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 490 33rd Ave | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/24/2013 12:00:00 AM | 3 | 3x3 | Permit Number 770137 | 5985656.77163 | 2112663.0068900003 | 37.780140206640205 | -122.493254729507 | (37.7801402066402, -122.493254729507) | |
16862 | 16862 | 22270 | DPW Maintained 3 | Lophostemon confertus :: Brisbane Box 11 | 4704 03rd St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 04/24/2015 03:01:00 PM | 3 | 3x3 | 6014985.2816 | 2095785.5021 | 37.7354699584644 | -122.39061347315001 | (37.7354699584644, -122.39061347315) | ||
72506 | 72506 | 109853 | DPW Maintained 3 | Lophostemon confertus :: Brisbane Box 11 | 2130 03rd St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 04/24/2015 03:05:00 PM | 3 | 2X3 | 6015587.1 | 2105686.2 | 37.7626885755012 | -122.3892238602 | (37.7626885755012, -122.3892238602) | ||
18364 | 18364 | 55861 | Permitted Site 1 | Tree(s) :: 17 | 217 Fair Oaks St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/25/1973 12:00:00 AM | Permit Number 11914 | 6005459.95361498 | 2102442.7771882 | 37.7532162699218 | -122.424019422199 | (37.7532162699218, -122.424019422199) | |||
81559 | 81559 | 55864 | Permitted Site 1 | Tree(s) :: 17 | 260 Fair Oaks St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/25/1973 12:00:00 AM | Permit Number 11917 | 6005421.03270414 | 2102195.08634379 | 37.752533970788896 | -122.42413640498998 | (37.7525339707889, -122.42413640499) | |||
83653 | 83653 | 56369 | Permitted Site 1 | Tree(s) :: 17 | 789 Carolina St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/25/1973 12:00:00 AM | Permit Number 12515 | 6012459.00313596 | 2104291.53872116 | 37.758685233977104 | -122.399944956637 | (37.7586852339771, -122.399944956637) | |||
113230 | 113230 | 55862 | Permitted Site 1 | Tree(s) :: 17 | 223 Fair Oaks St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/25/1973 12:00:00 AM | Permit Number 11915 | 6005461.72715169 | 2102409.37715669 | 37.753124661309705 | -122.42401091396401 | (37.7531246613097, -122.424010913964) | |||
113818 | 113818 | 55865 | Permitted Site 1 | Tree(s) :: 17 | 276 Fair Oaks St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/25/1973 12:00:00 AM | Permit Number 11919 | 6005425.76213351 | 2102106.01962778 | 37.7522896812413 | -122.424113716244 | (37.7522896812413, -122.424113716244) | |||
122455 | 122455 | 55863 | Permitted Site 1 | Zelkova serrata :: Sawleaf Zelkova 174 | 261 Fair Oaks St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/25/1973 12:00:00 AM | 12 | 3x3 | Permit Number 11916 | 6005472.95954935 | 2102197.84365155 | 37.752544473461704 | -122.423957028973 | (37.7525444734617, -122.423957028973) | |
143954 | 143954 | 55860 | Permitted Site 1 | Tree(s) :: 17 | 209 Fair Oaks St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/25/1973 12:00:00 AM | Permit Number 11912 | 6005457.58889975 | 2102487.31055661 | 37.75333841471571 | -122.42403076654301 | (37.7533384147157, -122.424030766543) | |||
18834 | 18834 | 58189 | Permitted Site 1 | Tree(s) :: 17 | 1886 41st Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/25/1978 12:00:00 AM | Permit Number 17176 | 5983531.02908859 | 2102317.07249767 | 37.751608654204 | -122.499843586703 | (37.751608654204, -122.499843586703) | |||
78795 | 78795 | 58187 | Permitted Site 1 | Tree(s) :: 17 | 605 Castro St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/25/1978 12:00:00 AM | 12 | 4x5 | Permit Number 17174 | 6002402.30039954 | 2104679.65463584 | 37.7591850949985 | -122.434753337297 | (37.7591850949985, -122.434753337297) | |
102542 | 102542 | 58190 | Permitted Site 1 | Tree(s) :: 17 | 1890 41st Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/25/1978 12:00:00 AM | Permit Number 17177 | 5983531.91784943 | 2102290.9609091 | 37.7515370111893 | -122.49983858346201 | (37.7515370111893, -122.499838583462) | |||
105711 | 105711 | 58188 | Permitted Site 1 | Tree(s) :: 17 | 4089 19th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/25/1978 12:00:00 AM | Permit Number 17175 | 6002445.51550246 | 2104696.0606841 | 37.759232595415895 | -122.434605052022 | (37.7592325954159, -122.434605052022) | |||
155396 | 155396 | 58718 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 650 Hayes St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/25/1979 12:00:00 AM | 12 | Permit Number 17952 | 6004735.14014 | 2110911.67442 | 37.7764288886158 | -122.427129149284 | (37.7764288886158, -122.427129149284) | ||
84206 | 84206 | 59070 | Permitted Site 1 | Tree(s) :: 17 | 37 Carl St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/25/1980 12:00:00 AM | Permit Number 18367 | 5998448.17915469 | 2107207.10289186 | 37.765899551930104 | -122.44861055838699 | (37.7658995519301, -122.448610558387) | |||
51 | 51 | 60867 | Permitted Site 1 | Tree(s) :: 17 | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/25/1983 12:00:00 AM | Permit Number 20649 | |||||||||
19180 | 19180 | 54063 | Permitted Site 1 | Tree(s) :: 17 | 338 23rd Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/25/1983 12:00:00 AM | Permit Number 20645 | 5988748.00808913 | 2113042.92844687 | 37.781363684027205 | -122.48258870985201 | (37.7813636840272, -122.482588709852) | |||
50904 | 50904 | 60868 | Permitted Site 1 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 37 Capistrano Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/25/1983 12:00:00 AM | 11 | Permit Number 20650 | 6001292.560409999 | 2093871.7493599998 | 37.7294460754672 | -122.437817248275 | (37.7294460754672, -122.437817248275) | ||
81007 | 81007 | 60866 | Permitted Site 1 | Tree(s) :: 17 | 3378 18th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/25/1983 12:00:00 AM | Permit Number 20648 | 6007002.66510081 | 2105586.34101678 | 37.7619347488124 | -122.41890733918999 | (37.7619347488124, -122.41890733919) | |||
83224 | 83224 | 60864 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 141 Pierce St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/25/1983 12:00:00 AM | 18 | 5x5 | Permit Number 20646 | 6002792.66965668 | 2109021.87772846 | 37.7711299378789 | -122.43371359916901 | (37.7711299378789, -122.433713599169) | |
85407 | 85407 | 60870 | Permitted Site 1 | Tree(s) :: 17 | 3161 Mission St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/25/1983 12:00:00 AM | Permit Number 20652 | 6006801.86266869 | 2099966.49884915 | 37.7464926434576 | -122.41920317849501 | (37.7464926434576, -122.419203178495) | |||
97879 | 97879 | 60869 | Permitted Site 1 | Tree(s) :: 17 | 2204 Bryant St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/25/1983 12:00:00 AM | Permit Number 20651 | 6009607.052229099 | 2104493.88712143 | 37.759081422547496 | -122.40982262996201 | (37.7590814225475, -122.409822629962) | |||
172319 | 172319 | 60865 | Permitted Site 1 | Magnolia grandiflora :: Southern Magnolia 21 | 2190 Broadway | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/25/1983 12:00:00 AM | 18 | Permit Number 20647 | 6003203.178780001 | 2117567.60312 | 37.7946176365522 | -122.432904251943 | (37.7946176365522, -122.432904251943) | ||
91805 | 91805 | 61411 | Permitted Site 1 | Tree(s) :: 17 | 1875 Buchanan St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/25/1984 12:00:00 AM | Permit Number 21335 | 6003926.293234901 | 2114845.96461001 | 37.7871856958386 | -122.43020792328801 | (37.7871856958386, -122.430207923288) | |||
117167 | 117167 | 61406 | Permitted Site 1 | Tree(s) :: 17 | 481 Church St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/25/1984 12:00:00 AM | Permit Number 21330 | 6004255.51008508 | 2106088.28235541 | 37.763157889423105 | -122.42844445037301 | (37.7631578894231, -122.428444450373) | |||
118580 | 118580 | 61412 | Permitted Site 1 | Tree(s) :: 17 | 1755 Geary Blvd | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/25/1984 12:00:00 AM | Permit Number 21336 | 6003089.72468815 | 2113779.94470094 | 37.7842112564891 | -122.43302607543501 | (37.7842112564891, -122.433026075435) | |||
122203 | 122203 | 61410 | Permitted Site 1 | Tree(s) :: 17 | 2666 Hyde St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/25/1984 12:00:00 AM | Permit Number 21334 | 6006945.26287472 | 2121452.77130571 | 37.805496862495396 | -122.42023200380301 | (37.8054968624954, -122.420232003803) | |||
7481 | 7481 | 21730 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 1955 Sutter St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/25/1990 12:00:00 AM | 6 | 3X3 | 6003249.1628 | 2114463.8768 | 37.786098203806205 | -122.43252334451599 | (37.7860982038062, -122.432523344516) | ||
95628 | 95628 | 66995 | Permitted Site 1 | Maytenus boaria :: Mayten 22 | 500 Urbano Dr | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 04/25/1992 12:00:00 AM | Permit Number 30349 | 5992613.77425874 | 2091862.9135908 | 37.723432982057204 | -122.46767435181101 | (37.7234329820572, -122.467674351811) | ||
23039 | 23039 | 25594 | DPW Maintained 3 | Pittosporum undulatum :: Victorian Box 26 | 1615 Cortland Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 04/25/1997 12:00:00 AM | 11 | 3X3 | 6009828.89634 | 2097439.37044 | 37.73972370857361 | -122.408557747048 | (37.7397237085736, -122.408557747048) | ||
112474 | 112474 | 25600 | Permitted Site 1 | Pittosporum undulatum :: Victorian Box 26 | 1495X Cortland Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/25/1997 12:00:00 AM | 3 | 3X3 | 6009546.950524299 | 2097468.8872034 | 37.7397889608515 | -122.40953468247801 | (37.7397889608515, -122.409534682478) | ||
143776 | 143776 | 25599 | DPW Maintained 3 | Pittosporum undulatum :: Victorian Box 26 | 1495X Cortland Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 04/25/1997 12:00:00 AM | 3 | 2X3 | 6009546.950524299 | 2097468.8872034 | 37.7397889608515 | -122.40953468247801 | (37.7397889608515, -122.409534682478) | ||
86999 | 86999 | 54321 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 1354 06th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 04/25/1998 12:00:00 AM | Permit Number 10082 | 5994285.87382261 | 2106296.87793954 | 37.7631614333228 | -122.462940955991 | (37.7631614333228, -122.462940955991) | ||
186861 | 186861 | 41550 | Permitted Site 1 | Arbutus unedo :: Strawberry Tree 61 | 2271 Clay St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/25/2000 12:00:00 AM | 5 | Permit Number 42072 | 6003891.05094 | 2116280.93986 | 37.7911237785009 | -122.430432278226 | (37.7911237785009, -122.430432278226) | ||
59 | 59 | 44994 | Permitted Site 1 | Tree(s) :: 17 | 106 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/25/2001 12:00:00 AM | Permit Number 43922 | |||||||||
444 | 444 | 44838 | Permitted Site 1 | Tree(s) :: 17 | 12 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/25/2001 12:00:00 AM | Permit Number 43922 | |||||||||
632 | 632 | 44905 | Permitted Site 1 | Tree(s) :: 17 | 139 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/25/2001 12:00:00 AM | Permit Number 43922 | |||||||||
726 | 726 | 44958 | Permitted Site 1 | Tree(s) :: 17 | 82 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/25/2001 12:00:00 AM | Permit Number 43922 | |||||||||
1499 | 1499 | 44884 | Permitted Site 1 | Tree(s) :: 17 | 157 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/25/2001 12:00:00 AM | Permit Number 43922 | |||||||||
2115 | 2115 | 44893 | Permitted Site 1 | Tree(s) :: 17 | 127 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/25/2001 12:00:00 AM | Permit Number 43922 | |||||||||
2154 | 2154 | 45014 | Permitted Site 1 | Tree(s) :: 17 | 86 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/25/2001 12:00:00 AM | Permit Number 43922 | |||||||||
2195 | 2195 | 44993 | Permitted Site 1 | Tree(s) :: 17 | 105 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/25/2001 12:00:00 AM | Permit Number 43922 | |||||||||
2366 | 2366 | 44966 | Permitted Site 1 | Tree(s) :: 17 | 79 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/25/2001 12:00:00 AM | Permit Number 43922 | |||||||||
2627 | 2627 | 44896 | Permitted Site 1 | Tree(s) :: 17 | 130 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/25/2001 12:00:00 AM | Permit Number 43922 | |||||||||
2630 | 2630 | 44978 | Permitted Site 1 | Tree(s) :: 17 | 50 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/25/2001 12:00:00 AM | Permit Number 43922 | |||||||||
2860 | 2860 | 44877 | Permitted Site 1 | Tree(s) :: 17 | 150 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/25/2001 12:00:00 AM | Permit Number 43922 | |||||||||
2945 | 2945 | 44998 | Permitted Site 1 | Tree(s) :: 17 | 110 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/25/2001 12:00:00 AM | Permit Number 43922 | |||||||||
2960 | 2960 | 44920 | Permitted Site 1 | Tree(s) :: 17 | 182 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/25/2001 12:00:00 AM | Permit Number 43922 | |||||||||
3134 | 3134 | 44852 | Permitted Site 1 | Tree(s) :: 17 | 37 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/25/2001 12:00:00 AM | Permit Number 43922 | |||||||||
3285 | 3285 | 44952 | Permitted Site 1 | Tree(s) :: 17 | 65 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/25/2001 12:00:00 AM | Permit Number 43922 | |||||||||
3408 | 3408 | 44959 | Permitted Site 1 | Tree(s) :: 17 | 72 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/25/2001 12:00:00 AM | Permit Number 43922 | |||||||||
3543 | 3543 | 44857 | Permitted Site 1 | Tree(s) :: 17 | 31 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/25/2001 12:00:00 AM | Permit Number 43922 | |||||||||
4831 | 4831 | 44933 | Permitted Site 1 | Tree(s) :: 17 | 166 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/25/2001 12:00:00 AM | Permit Number 43922 | |||||||||
5128 | 5128 | 44995 | Permitted Site 1 | Tree(s) :: 17 | 107 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/25/2001 12:00:00 AM | Permit Number 43922 | |||||||||
5156 | 5156 | 44926 | Permitted Site 1 | Tree(s) :: 17 | 199 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/25/2001 12:00:00 AM | Permit Number 43922 | |||||||||
5360 | 5360 | 45002 | Permitted Site 1 | Tree(s) :: 17 | 114 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/25/2001 12:00:00 AM | Permit Number 43922 | |||||||||
5386 | 5386 | 44855 | Permitted Site 1 | Tree(s) :: 17 | 17 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/25/2001 12:00:00 AM | Permit Number 43922 | |||||||||
5392 | 5392 | 44924 | Permitted Site 1 | Tree(s) :: 17 | 197 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/25/2001 12:00:00 AM | Permit Number 43922 | |||||||||
5393 | 5393 | 44945 | Permitted Site 1 | Tree(s) :: 17 | 178 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/25/2001 12:00:00 AM | Permit Number 43922 | |||||||||
5552 | 5552 | 44936 | Permitted Site 1 | Tree(s) :: 17 | 169 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/25/2001 12:00:00 AM | Permit Number 43922 | |||||||||
5567 | 5567 | 44850 | Permitted Site 1 | Tree(s) :: 17 | 39 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/25/2001 12:00:00 AM | Permit Number 43922 | |||||||||
5571 | 5571 | 44915 | Permitted Site 1 | Tree(s) :: 17 | 188 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/25/2001 12:00:00 AM | Permit Number 43922 | |||||||||
5581 | 5581 | 44876 | Permitted Site 1 | Tree(s) :: 17 | 149 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/25/2001 12:00:00 AM | Permit Number 43922 | |||||||||
5590 | 5590 | 45005 | Permitted Site 1 | Tree(s) :: 17 | 117 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/25/2001 12:00:00 AM | Permit Number 43922 | |||||||||
5838 | 5838 | 45000 | Permitted Site 1 | Tree(s) :: 17 | 112 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/25/2001 12:00:00 AM | Permit Number 43922 | |||||||||
5978 | 5978 | 44929 | Permitted Site 1 | Tree(s) :: 17 | 191 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/25/2001 12:00:00 AM | Permit Number 43922 | |||||||||
6129 | 6129 | 44935 | Permitted Site 1 | Tree(s) :: 17 | 168 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/25/2001 12:00:00 AM | Permit Number 43922 | |||||||||
6138 | 6138 | 44892 | Permitted Site 1 | Tree(s) :: 17 | 126 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/25/2001 12:00:00 AM | Permit Number 43922 | |||||||||
6145 | 6145 | 45017 | Permitted Site 1 | Tree(s) :: 17 | 89 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/25/2001 12:00:00 AM | Permit Number 43922 | |||||||||
6244 | 6244 | 44878 | Permitted Site 1 | Tree(s) :: 17 | 151 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/25/2001 12:00:00 AM | Permit Number 43922 | |||||||||
6286 | 6286 | 44854 | Permitted Site 1 | Tree(s) :: 17 | 35 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/25/2001 12:00:00 AM | Permit Number 43922 | |||||||||
6321 | 6321 | 45023 | Permitted Site 1 | Tree(s) :: 17 | 96 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/25/2001 12:00:00 AM | Permit Number 43922 | |||||||||
6351 | 6351 | 44930 | Permitted Site 1 | Tree(s) :: 17 | 173 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/25/2001 12:00:00 AM | Permit Number 43922 | |||||||||
6393 | 6393 | 44910 | Permitted Site 1 | Tree(s) :: 17 | 193 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/25/2001 12:00:00 AM | Permit Number 43922 | |||||||||
6426 | 6426 | 44973 | Permitted Site 1 | Tree(s) :: 17 | 45 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/25/2001 12:00:00 AM | Permit Number 43922 | |||||||||
6456 | 6456 | 45004 | Permitted Site 1 | Tree(s) :: 17 | 116 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/25/2001 12:00:00 AM | Permit Number 43922 | |||||||||
6560 | 6560 | 44839 | Permitted Site 1 | Tree(s) :: 17 | 13 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/25/2001 12:00:00 AM | Permit Number 43922 | |||||||||
6600 | 6600 | 45003 | Permitted Site 1 | Tree(s) :: 17 | 115 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/25/2001 12:00:00 AM | Permit Number 43922 |
JSON shape: default, array, newline-delimited
CREATE TABLE "Street_Tree_List" ( "TreeID" INTEGER, "qLegalStatus" INTEGER, "qSpecies" INTEGER, "qAddress" TEXT, "SiteOrder" INTEGER, "qSiteInfo" INTEGER, "PlantType" INTEGER, "qCaretaker" INTEGER, "qCareAssistant" INTEGER, "PlantDate" TEXT, "DBH" INTEGER, "PlotSize" TEXT, "PermitNotes" TEXT, "XCoord" REAL, "YCoord" REAL, "Latitude" REAL, "Longitude" REAL, "Location" TEXT , FOREIGN KEY ("PlantType") REFERENCES [PlantType](id), FOREIGN KEY ("qCaretaker") REFERENCES [qCaretaker](id), FOREIGN KEY ("qSpecies") REFERENCES [qSpecies](id), FOREIGN KEY ("qSiteInfo") REFERENCES [qSiteInfo](id), FOREIGN KEY ("qCareAssistant") REFERENCES [qCareAssistant](id), FOREIGN KEY ("qLegalStatus") REFERENCES [qLegalStatus](id)); CREATE INDEX ["Street_Tree_List_PlantType"] ON [Street_Tree_List]("PlantType"); CREATE INDEX ["Street_Tree_List_qCaretaker"] ON [Street_Tree_List]("qCaretaker"); CREATE INDEX ["Street_Tree_List_qSpecies"] ON [Street_Tree_List]("qSpecies"); CREATE INDEX ["Street_Tree_List_qSiteInfo"] ON [Street_Tree_List]("qSiteInfo"); CREATE INDEX ["Street_Tree_List_qCareAssistant"] ON [Street_Tree_List]("qCareAssistant"); CREATE INDEX ["Street_Tree_List_qLegalStatus"] ON [Street_Tree_List]("qLegalStatus");