Data source: data.sfgov.org
This data as json, CSV (advanced)
Link | rowid | TreeID | qLegalStatus | qSpecies | qAddress | SiteOrder | qSiteInfo | PlantType | qCaretaker | qCareAssistant | PlantDate | DBH | PlotSize | PermitNotes | XCoord ▼ | YCoord | Latitude | Longitude | Location |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
125226 | 125226 | 70167 | Undocumented 2 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 | 831 45th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/12/2015 12:00:00 AM | 3 | Permit Number 773700 | 5981976.78091 | 2110066.45395 | 37.772794906459 | -122.505792724366 | (37.772794906459, -122.505792724366) | |
184438 | 184438 | 119038 | Undocumented 2 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 | 675 44th Ave | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 3 | Width 4ft | 5982249.27103 | 2111200.72651 | 37.7759253222044 | -122.50493423498501 | (37.7759253222044, -122.504934234985) | |||
59077 | 59077 | 118718 | Undocumented 2 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 | 818 44th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 3ft | 5982331.02075 | 2110159.51383 | 37.7730712650544 | -122.504574285424 | (37.7730712650544, -122.504574285424) | |||
174370 | 174370 | 71615 | Undocumented 2 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 | 536 40th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/14/1995 12:00:00 AM | 2 | 5983503.66193 | 2112151.1699 | 37.7786086821922 | -122.500665338334 | (37.7786086821922, -122.500665338334) | ||
155447 | 155447 | 118202 | Undocumented 2 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 | 744 35th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 4ft | 5985103.04881 | 2110791.51915 | 37.774969236334 | -122.495032243047 | (37.774969236334, -122.495032243047) | |||
53029 | 53029 | 118073 | Undocumented 2 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 | 449 34th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 3ft | 5985293.2738 | 2112845.5441799997 | 37.7806201339604 | -122.49452567585199 | (37.7806201339604, -122.494525675852) | |||
30883 | 30883 | 119446 | Undocumented 2 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 | 881 32nd Ave | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 2 | Width 6ft | 5986011.18097 | 2109924.94508 | 37.7726429911374 | -122.49182705320801 | (37.7726429911374, -122.491827053208) | |||
117109 | 117109 | 105717 | Undocumented 2 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 | 409 26th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | 3x3 | 5987766.351369999 | 2113121.02315 | 37.7815209517603 | -122.485990454458 | (37.7815209517603, -122.485990454458) | |||
188986 | 188986 | 120093 | Undocumented 2 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 | 655 26th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 3ft | 5987822.4003099995 | 2111507.4982 | 37.7770939337825 | -122.485678099475 | (37.7770939337825, -122.485678099475) | |||
52885 | 52885 | 120377 | Undocumented 2 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 | 101 25th Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 2ft | 5987995.9910699995 | 2115194.27342 | 37.7872268871617 | -122.485348201277 | (37.7872268871617, -122.485348201277) | |||
73825 | 73825 | 120376 | Undocumented 2 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 | 123 25th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 2ft | 5987996.34408 | 2115176.14425 | 37.787177130208995 | -122.48534564914301 | (37.787177130209, -122.485345649143) | |||
132678 | 132678 | 120242 | Undocumented 2 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 | 288 24th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 3ft | 5988397.89946 | 2114035.20565 | 37.7840678224086 | -122.483872680677 | (37.7840678224086, -122.483872680677) | |||
159521 | 159521 | 120234 | Undocumented 2 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 | 896 24th Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 3ft | 5988543.40273 | 2109982.31108 | 37.7729481790861 | -122.48307213983601 | (37.7729481790861, -122.483072139836) | |||
66578 | 66578 | 70266 | Undocumented 2 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 | 414 23rd Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 02/17/1996 12:00:00 AM | 8 | 5988762.33088 | 2112478.2196299997 | 37.7798139854521 | -122.482497769619 | (37.7798139854521, -122.482497769619) | ||
39564 | 39564 | 120406 | Undocumented 2 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 | 619 23rd Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 3ft | 5988769.80583 | 2111094.18017 | 37.7760142347438 | -122.48237047472901 | (37.7760142347438, -122.482370474729) | |||
136936 | 136936 | 120427 | Undocumented 2 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 | 459 22nd Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 3ft | 5989038.74655 | 2112201.43488 | 37.7790700882049 | -122.481521260476 | (37.7790700882049, -122.481521260476) | |||
34906 | 34906 | 120793 | Undocumented 2 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 | 559 21st Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 3ft | 5989373.68445 | 2111524.6737 | 37.7772313596652 | -122.48031303988998 | (37.7772313596652, -122.48031303989) | |||
160936 | 160936 | 121810 | Undocumented 2 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 | 106 19th Ave | 2 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 4 | Width 4ft | 5989928.89895 | 2114601.72994 | 37.7857123459232 | -122.478617478776 | (37.7857123459232, -122.478617478776) | |||
181254 | 181254 | 208834 | Undocumented 2 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 | 1669 18th Ave | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 1 | Width 3ft | 5990551.61783 | 2104055.61326 | 37.756791716882404 | -122.47569268998699 | (37.7567917168824, -122.475692689987) | |||
148326 | 148326 | 208833 | Undocumented 2 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 | 1655 18th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 3ft | 5990561.21502 | 2104064.77483 | 37.75681742851079 | -122.47566016868299 | (37.7568174285108, -122.475660168683) | |||
52959 | 52959 | 208835 | Undocumented 2 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 | 1673 18th Ave | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 2 | Width 3ft | 5990563.36006 | 2104017.9082 | 37.7566888695243 | -122.475649328274 | (37.7566888695243, -122.475649328274) | |||
30218 | 30218 | 208836 | Undocumented 2 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 | 1677 18th Ave | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 1 | Width 3ft | 5990563.73281 | 2104000.71919 | 37.756641694668396 | -122.47564678406499 | (37.7566416946684, -122.475646784065) | |||
172445 | 172445 | 121908 | Undocumented 2 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 | 320 17th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 3ft | 5990601.2313 | 2113229.42539 | 37.781983392499704 | -122.476191154353 | (37.7819833924997, -122.476191154353) | |||
137500 | 137500 | 208837 | Undocumented 2 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 | 1958 17th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 2ft | 5990984.78596 | 2102065.3313 | 37.7513520289909 | -122.474049439736 | (37.7513520289909, -122.474049439736) | |||
38343 | 38343 | 122390 | Undocumented 2 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 | 1958 17th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 3x2 | 5991007.0 | 2102078.0 | 37.7513881006776 | -122.47397354599501 | (37.7513881006776, -122.473973545995) | |||
133119 | 133119 | 122152 | Undocumented 2 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 | 263 15th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 4ft | 5991173.60125 | 2113665.4764900003 | 37.783213842540796 | -122.474242864812 | (37.7832138425408, -122.474242864812) | |||
157233 | 157233 | 208838 | Undocumented 2 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 | 1450 16th Ave | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 2 | Width 5ft | 5991176.37038 | 2105519.1814900003 | 37.7608464875004 | -122.47363884617799 | (37.7608464875004, -122.473638846178) | |||
161888 | 161888 | 217796 | Undocumented 2 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 | 21 Sloat Blvd | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 3 | Width 5ft | 5991264.945169999 | 2095927.55542 | 37.7345154980788 | -122.472633170284 | (37.7345154980788, -122.472633170284) | |||
69848 | 69848 | 81662 | Undocumented 2 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 | 563 14th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 4 | 5991577.12734 | 2111607.04314 | 37.7775853186785 | -122.472696706975 | (37.7775853186785, -122.472696706975) | |||
73090 | 73090 | 123057 | Undocumented 2 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 | 514 Funston Ave | 2 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 5 | Width 4ft | 5991919.1397400005 | 2111920.98536 | 37.778467110254795 | -122.47153646453998 | (37.7784671102548, -122.47153646454) | |||
67154 | 67154 | 122918 | Undocumented 2 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 | 336 12th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 3ft | 5992182.56375 | 2113171.96239 | 37.781917187404794 | -122.470716333226 | (37.7819171874048, -122.470716333226) | |||
163844 | 163844 | 123126 | Undocumented 2 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 | 771 11th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 4ft | 5992555.29457 | 2110202.5485900003 | 37.773785530078605 | -122.469210678659 | (37.7737855300786, -122.469210678659) | |||
180785 | 180785 | 123123 | Undocumented 2 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 | 780 11th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11 | Width 3ft | 5992600.03768 | 2110148.99607 | 37.77364107460671 | -122.469052008303 | (37.7736410746067, -122.469052008303) | |||
152854 | 152854 | 208839 | Undocumented 2 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 | 131 Wawona St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 3ft | 5992959.48741 | 2098205.81206 | 37.74086896193 | -122.466940197353 | (37.74086896193, -122.466940197353) | |||
130198 | 130198 | 208841 | Undocumented 2 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 | 2134 09th Ave | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 2 | Width 4ft | 5993696.59277 | 2101147.8080700003 | 37.74898945599679 | -122.46460515623001 | (37.7489894559968, -122.46460515623) | |||
75476 | 75476 | 208842 | Undocumented 2 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 | 168 Dorantes Ave | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 3 | Width 4ft | 5993717.6087 | 2099811.01881 | 37.7453201833801 | -122.46443543703998 | (37.7453201833801, -122.46443543704) | |||
27684 | 27684 | 208849 | Undocumented 2 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 | 15 Santa Rita Ave | 4 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 24 | Width 3ft | 5993729.602000001 | 2100694.18749 | 37.7477458321253 | -122.464458079273 | (37.7477458321253, -122.464458079273) | |||
135397 | 135397 | 218385 | Undocumented 2 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 | 50 San Marcos Ave | 7 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 4 | Width 0ft | 5993842.10795 | 2100214.10934 | 37.7464341439306 | -122.46403419821999 | (37.7464341439306, -122.46403419822) | |||
36826 | 36826 | 218387 | Undocumented 2 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 | 50 San Marcos Ave | 9 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 2 | Width 0ft | 5993857.52408 | 2100226.90247 | 37.746470159084396 | -122.46398181990101 | (37.7464701590844, -122.463981819901) | |||
146559 | 146559 | 208848 | Undocumented 2 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 | 281 Lobos St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 3ft | 5994210.24416 | 2088699.7294 | 37.7148396860693 | -122.46192642387501 | (37.7148396860693, -122.461926423875) | |||
37388 | 37388 | 123549 | Undocumented 2 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 | 65 05th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 5ft | 5994237.46417 | 2115165.09446 | 37.7875084040974 | -122.46375209006099 | (37.7875084040974, -122.463752090061) | |||
73056 | 73056 | 123366 | Undocumented 2 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 | 780 04th Ave | 2 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 3 | Width 4ft | 5994765.69029 | 2110380.32738 | 37.774401141157796 | -122.461577514019 | (37.7744011411578, -122.461577514019) | |||
171396 | 171396 | 123367 | Undocumented 2 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 | 780 04th Ave | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 2 | Width 4ft | 5994765.802759999 | 2110367.1849 | 37.774365061862504 | -122.461576171928 | (37.7743650618625, -122.461576171928) | |||
77158 | 77158 | 208851 | Undocumented 2 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 | 185 Vasquez Ave | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 4 | Width 3ft | 5994827.47674 | 2099365.31036 | 37.7441602944536 | -122.46056543215299 | (37.7441602944536, -122.460565432153) | |||
135913 | 135913 | 208850 | Undocumented 2 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 | 185 Vasquez Ave | 2 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 4 | Width 3ft | 5994846.41703 | 2099381.9265400004 | 37.7442070079607 | -122.46050114503001 | (37.7442070079607, -122.46050114503) | |||
71656 | 71656 | 123425 | Undocumented 2 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 | 642 03rd Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 23 | Width 3ft | 5995046.062419999 | 2111151.48991 | 37.7765346834922 | -122.460663556381 | (37.7765346834922, -122.460663556381) | |||
76787 | 76787 | 208846 | Undocumented 2 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 | 36 De Montfort Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 3ft | 5995163.31564 | 2091909.32906 | 37.7237073072365 | -122.45886447241999 | (37.7237073072365, -122.45886447242) | |||
24356 | 24356 | 123622 | Undocumented 2 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 | 111 02nd Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 3ft | 5995179.48554 | 2114830.2995 | 37.786643385410706 | -122.460468639914 | (37.7866433854107, -122.460468639914) | |||
68109 | 68109 | 112522 | Undocumented 2 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 | 195 02nd Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 09/09/2015 12:00:00 AM | 1 | 3x3 | Permit Number 776238 | 5995198.14893 | 2114301.9969900004 | 37.7851938828924 | -122.460365776533 | (37.7851938828924, -122.460365776533) | |
72706 | 72706 | 112523 | Undocumented 2 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 | 195 02nd Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 09/09/2015 12:00:00 AM | 1 | 3x3 | Permit Number 776238 | 5995199.36548 | 2114291.31706 | 37.7851646286632 | -122.46036079357799 | (37.7851646286632, -122.460360793578) | |
71293 | 71293 | 208847 | Undocumented 2 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 | 422 Grafton Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 3ft | 5995505.44933 | 2090582.5246599999 | 37.7200838784427 | -122.457585828931 | (37.7200838784427, -122.457585828931) | |||
129834 | 129834 | 208845 | Undocumented 2 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 | 277 Granada Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 3ft | 5995629.339 | 2091829.15928 | 37.7235139565963 | -122.457247722532 | (37.7235139565963, -122.457247722532) | |||
182305 | 182305 | 208844 | Undocumented 2 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 | 335 Colon Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 1ft | 5995829.06738 | 2094841.15023 | 37.731795629859796 | -122.45677503524901 | (37.7317956298598, -122.456775035249) | |||
25024 | 25024 | 208840 | Undocumented 2 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 | 1350 Plymouth Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 2ft | 5995903.3540199995 | 2092975.62657 | 37.7266776159651 | -122.456383367909 | (37.7266776159651, -122.456383367909) | |||
158279 | 158279 | 124566 | Undocumented 2 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 | 3943 Sacramento St | 1 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 2 | Width 4ft | 5995914.73243 | 2114852.9465900003 | 37.7867478376308 | -122.457926519067 | (37.7867478376308, -122.457926519067) | |||
75641 | 75641 | 124612 | Undocumented 2 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 | 3931 Clay St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 3ft | 5995955.42177 | 2115180.15749 | 37.7876486084254 | -122.457809430854 | (37.7876486084254, -122.457809430854) | |||
42403 | 42403 | 124334 | Undocumented 2 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 | 176 Palm Ave | 3 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 1 | Width 4ft | 5995958.15323 | 2113125.95358 | 37.782008471168 | -122.457651289636 | (37.782008471168, -122.457651289636) | |||
32960 | 32960 | 124335 | Undocumented 2 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 | 176 Palm Ave | 2 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 2 | Width 2ft | 5995959.20478 | 2113110.98096 | 37.78196742074471 | -122.457646568088 | (37.7819674207447, -122.457646568088) | |||
68652 | 68652 | 124611 | Undocumented 2 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 | 3931 Clay St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 3ft | 5995971.07063 | 2115182.72875 | 37.787656567418 | -122.457755475318 | (37.787656567418, -122.457755475318) | |||
168053 | 168053 | 72311 | Undocumented 2 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 | 3769 Jackson St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 02/10/1996 12:00:00 AM | 4 | 5996250.37824 | 2115874.5059700003 | 37.7895720432509 | -122.456839183887 | (37.7895720432509, -122.456839183887) | ||
44983 | 44983 | 250184 | Undocumented 2 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 | 665 Parker Ave | 1 | : 4 | Tree 1 | Private 1 | 2 | Width 4ft | 5997216.13133 | 2110917.44789 | 37.7760166771611 | -122.45313980466699 | (37.7760166771611, -122.453139804667) | |||
68072 | 68072 | 250185 | Undocumented 2 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 | 665 Parker Ave | 2 | : 4 | Tree 1 | Private 1 | 2 | Width 4ft | 5997218.614440001 | 2110901.95743 | 37.7759742867055 | -122.453130096488 | (37.7759742867055, -122.453130096488) | |||
169196 | 169196 | 250186 | Undocumented 2 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 | 665 Parker Ave | 3 | : 4 | Tree 1 | Private 1 | 2 | Width 4ft | 5997220.39466 | 2110886.1472400003 | 37.7759309780695 | -122.4531227967 | (37.7759309780695, -122.4531227967) | |||
60128 | 60128 | 250187 | Undocumented 2 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 | 665 Parker Ave | 4 | : 4 | Tree 1 | Private 1 | 1 | Width 4ft | 5997222.68042 | 2110871.6887 | 37.7758914096851 | -122.453113845732 | (37.7758914096851, -122.453113845732) | |||
68631 | 68631 | 208843 | Undocumented 2 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 | 40 Agua Way | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 2ft | 5997291.06099 | 2098595.63938 | 37.74218838968729 | -122.451991423486 | (37.7421883896873, -122.451991423486) | |||
65862 | 65862 | 130969 | Undocumented 2 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 | 95 Heather Ave | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 1 | 5997355.4901 | 2113891.63765 | 37.7841910082488 | -122.452872452398 | (37.7841910082488, -122.452872452398) | ||||
32904 | 32904 | 130968 | Undocumented 2 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 | 95 Heather Ave | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 1 | 5997356.6821800005 | 2113906.91877 | 37.7842330344764 | -122.45286943159799 | (37.7842330344764, -122.452869431598) | ||||
181142 | 181142 | 208857 | Undocumented 2 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 | 1 Gennessee St | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 1 | Width 8ft | 5997408.7613699995 | 2093610.5667299998 | 37.7285073190505 | -122.451225020336 | (37.7285073190505, -122.451225020336) | |||
53993 | 53993 | 177425 | Undocumented 2 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 | 1764 Cayuga Ave | 3 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 14 | Width 8ft | 5997936.35064 | 2088551.93116 | 37.7146476772225 | -122.44903686276301 | (37.7146476772225, -122.449036862763) | |||
79213 | 79213 | 121338 | Undocumented 2 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 | 1543 Cole St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 09/26/2016 12:00:00 AM | 3 | 3x3 | Permit Number 778568 | 5998304.86118 | 2105256.47064 | 37.7605354110025 | -122.44896573677 | (37.7605354110025, -122.44896573677) | |
48031 | 48031 | 130967 | Undocumented 2 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 | 213 Walnut St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 4ft | 5998523.7164 | 2115638.03819 | 37.7890530400256 | -122.448956666639 | (37.7890530400256, -122.448956666639) | |||
164978 | 164978 | 246941 | Undocumented 2 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 | 269 Frederick St | 1 | : 4 | Tree 1 | Private 1 | 2 | Width 3ft | 5998752.122880001 | 2107600.5740099996 | 37.7669972990085 | -122.447587610674 | (37.7669972990085, -122.447587610674) | |||
39525 | 39525 | 208855 | Undocumented 2 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 | 358 Mangels Ave | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 3 | Width 4ft | 5999047.687609999 | 2095262.2243 | 37.7331360864596 | -122.445677914709 | (37.7331360864596, -122.445677914709) | |||
168749 | 168749 | 130985 | Undocumented 2 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 | 2098 Jefferson St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 3ft | 5999249.259269999 | 2121180.66389 | 37.8043130782603 | -122.44684538130501 | (37.8043130782603, -122.446845381305) | |||
160542 | 160542 | 130984 | Undocumented 2 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 | 2200 Beach St | 7 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 1 | Width 4ft | 5999592.955130001 | 2120888.49408 | 37.803530487293 | -122.445634974783 | (37.803530487293, -122.445634974783) | |||
55251 | 55251 | 130983 | Undocumented 2 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 | 2200 Beach St | 6 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 1 | Width 4ft | 5999604.2907300005 | 2120890.91469 | 37.8035377808009 | -122.44559592174 | (37.8035377808009, -122.44559592174) | |||
45725 | 45725 | 130982 | Undocumented 2 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 | 3601 Broderick St | 6 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 3 | Width 4ft | 5999659.44076 | 2120919.3234599996 | 37.8036189320344 | -122.44540711714701 | (37.8036189320344, -122.445407117147) | |||
29022 | 29022 | 208856 | Undocumented 2 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 | 331 Joost Ave | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 6 | Width 10ft | 5999876.46994 | 2094937.06877 | 37.732290569037104 | -122.44278926080901 | (37.7322905690371, -122.442789260809) | |||
155510 | 155510 | 177423 | Undocumented 2 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 | 270 Delano Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 3ft | 5999939.77666 | 2092147.8586099998 | 37.7246356530907 | -122.44237022711701 | (37.7246356530907, -122.442370227117) | |||
60469 | 60469 | 80737 | Undocumented 2 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 | 186 Allison St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 03/22/2003 12:00:00 AM | 1 | 6000043.5525400005 | 2087718.3093599998 | 37.7124790304587 | -122.44169374357 | (37.7124790304587, -122.44169374357) | ||
39201 | 39201 | 177424 | Undocumented 2 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 | 85 Santa Ynez Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 3ft | 6000559.946819999 | 2092109.10715 | 37.7245645787726 | -122.440223605655 | (37.7245645787726, -122.440223605655) | |||
59745 | 59745 | 208853 | Undocumented 2 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 | 54 Martha Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 15 | Width 2ft | 6000650.73977 | 2095621.13276 | 37.734212959854396 | -122.440161475975 | (37.7342129598544, -122.440161475975) | |||
165587 | 165587 | 208854 | Undocumented 2 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 | 403 Baden St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 3ft | 6000738.2575199995 | 2095246.2380099997 | 37.7331885682037 | -122.439832030035 | (37.7331885682037, -122.439832030035) | |||
3940 | 3940 | 179536 | Undocumented 2 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 | 1880 Alemany Blvd | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/04/2017 10:42:00 AM | 3 | Width 3ft | 6000969.55481 | 2091096.3953200001 | 37.7218072142025 | -122.438735113438 | (37.7218072142025, -122.438735113438) | ||
35817 | 35817 | 83433 | Undocumented 2 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 | 760 Paris St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/03/2005 12:00:00 AM | 4 | 6000998.571 | 2089370.50235 | 37.7170699516967 | -122.43851121642099 | (37.7170699516967, -122.438511216421) | ||
151961 | 151961 | 177422 | Undocumented 2 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 | 0 Santa Ynez Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 4ft | 6001061.39064 | 2091803.12496 | 37.7237529577069 | -122.438468271097 | (37.7237529577069, -122.438468271097) | |||
23977 | 23977 | 177421 | Undocumented 2 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 | 0 Santa Ynez Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 4ft | 6001079.38248 | 2091791.86287 | 37.7237230579705 | -122.438405269984 | (37.7237230579705, -122.438405269984) | |||
47177 | 47177 | 177448 | Undocumented 2 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 | 1022 Prague St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 4ft | 6001291.58576 | 2086844.2282099999 | 37.7101500273691 | -122.437317616421 | (37.7101500273691, -122.437317616421) | |||
54260 | 54260 | 177419 | Undocumented 2 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 | 100 Capistrano Ave | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 2ft | 6001443.854169999 | 2093560.7227900003 | 37.7286006695825 | -122.437271950666 | (37.7286006695825, -122.437271950666) | |||
153633 | 153633 | 247755 | Undocumented 2 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 | 52 Alpine Ter | 1 | : 4 | Tree 1 | Private 1 | 2 | Width 3ft | 6001613.95356 | 2108514.35375 | 37.7696694492075 | -122.43775445760299 | (37.7696694492075, -122.437754457603) | |||
49219 | 49219 | 247756 | Undocumented 2 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 | 52 Alpine Ter | 2 | : 4 | Tree 1 | Private 1 | 3 | Width 3ft | 6001615.48849 | 2108494.65039 | 37.7696154359451 | -122.437747736977 | (37.7696154359451, -122.437747736977) | |||
29927 | 29927 | 83659 | Undocumented 2 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 | 559 Paris St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/03/2005 12:00:00 AM | 6 | 6001685.54257 | 2090383.4533900002 | 37.7198903425557 | -122.436209138162 | (37.7198903425557, -122.436209138162) | ||
74610 | 74610 | 230333 | Undocumented 2 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 | 629 28th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 2ft | 6001808.677069999 | 2099403.33262 | 37.7446638554471 | -122.436428732821 | (37.7446638554471, -122.436428732821) | |||
28727 | 28727 | 177449 | Undocumented 2 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 | 324 Cordova St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 3ft | 6001907.3749400005 | 2086972.3844599999 | 37.7105369040276 | -122.43519848992901 | (37.7105369040276, -122.435198489929) | |||
23545 | 23545 | 177395 | Undocumented 2 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 | 715 Madrid St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 2ft | 6001937.656140001 | 2089768.77997 | 37.718216907458704 | -122.435293726344 | (37.7182169074587, -122.435293726344) | |||
151066 | 151066 | 230349 | Undocumented 2 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 | 222 Surrey St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 2ft | 6001969.40377 | 2096197.83075 | 37.735871425709995 | -122.43564368671801 | (37.73587142571, -122.435643686718) | |||
26535 | 26535 | 177420 | Undocumented 2 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 | 121 Cotter St | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 1 | Width 3ft | 6001985.26237 | 2093449.7289900002 | 37.728326668619296 | -122.435392337892 | (37.7283266686193, -122.435392337892) | |||
138917 | 138917 | 98077 | Undocumented 2 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 | 731 Duboce Ave | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 6001992.2 | 2108216.2 | 37.768872292925295 | -122.436424775079 | (37.7688722929253, -122.436424775079) | |||||
177264 | 177264 | 110562 | Undocumented 2 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 | 135 Theresa St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | 3x9 | 6002071.86629 | 2093721.73728 | 37.729078459595605 | -122.43511239152001 | (37.7290784595956, -122.43511239152) | |||
172336 | 172336 | 110563 | Undocumented 2 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 | 135 Theresa St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | 3x9 | 6002082.973999999 | 2093709.6113599997 | 37.729045795311706 | -122.43507312442499 | (37.7290457953117, -122.435073124425) |
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");