Data source: data.sfgov.org
This data as json, CSV (advanced)
Suggested facets: qLegalStatus, qSiteInfo, qCaretaker, qCareAssistant
| Link | rowid | TreeID | qLegalStatus | qSpecies | qAddress | SiteOrder | qSiteInfo ▲ | PlantType | qCaretaker | qCareAssistant | PlantDate | DBH | PlotSize | PermitNotes | XCoord | YCoord | Latitude | Longitude | Location |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 47947 | 47947 | 130534 | Undocumented 2 | Magnolia grandiflora :: Southern Magnolia 21 | 200 Spruce St | 6 | Side Yard : Yard 17 | Tree 1 | Private 1 | 11 | Width 4ft | 5997125.56519 | 2115595.68583 | 37.7888566928265 | -122.453791002876 | (37.7888566928265, -122.453791002876) | |||
| 58449 | 58449 | 130533 | Undocumented 2 | Magnolia grandiflora :: Southern Magnolia 21 | 200 Spruce St | 5 | Side Yard : Yard 17 | Tree 1 | Private 1 | 12 | Width 4ft | 5997122.58531 | 2115614.86787 | 37.7889091907409 | -122.453802698553 | (37.7889091907409, -122.453802698553) | |||
| 159471 | 159471 | 130532 | Undocumented 2 | Magnolia grandiflora :: Southern Magnolia 21 | 200 Spruce St | 3 | Side Yard : Yard 17 | Tree 1 | Private 1 | 12 | Width 4ft | 5997120.56574 | 2115634.70295 | 37.7889635367836 | -122.45381111889799 | (37.7889635367836, -122.453811118898) | |||
| 187893 | 187893 | 130609 | Undocumented 2 | Magnolia grandiflora :: Southern Magnolia 21 | 1500 Beach St | 1 | Side Yard : Yard 17 | Tree 1 | Private 1 | 20 | 6002918.83172 | 2121356.11513 | 37.80500377108171 | -122.43415909039699 | (37.8050037710817, -122.434159090397) | ||||
| 40928 | 40928 | 250002 | Undocumented 2 | Magnolia grandiflora :: Southern Magnolia 21 | 21 Darrell Pl | 1 | Back Yard : Yard 13 | Tree 1 | Private 1 | 9 | Width 0ft | 6011523.15034 | 2120119.58855 | 37.8020931539352 | -122.40429561796499 | (37.8020931539352, -122.404295617965) | |||
| 215 | 215 | 17196 | DPW Maintained 3 | Magnolia grandiflora :: Southern Magnolia 21 | 2235X Octavia St | 5 | Median : Cutout 11 | Tree 1 | DPW 2 | 24 | 20 | 6004629.787409999 | 2116932.39582 | 37.792954330542 | -122.42792271466601 | (37.792954330542, -122.427922714666) | |||
| 5356 | 5356 | 17193 | DPW Maintained 3 | Magnolia grandiflora :: Southern Magnolia 21 | 2235X Octavia St | 2 | Median : Cutout 11 | Tree 1 | DPW 2 | 24 | 20 | 6004642.48731 | 2116869.91995 | 37.792783506093706 | -122.427874318555 | (37.7927835060937, -122.427874318555) | |||
| 9024 | 9024 | 17192 | DPW Maintained 3 | Magnolia grandiflora :: Southern Magnolia 21 | 2235X Octavia St | 1 | Median : Cutout 11 | Tree 1 | DPW 2 | 12 | 20 | 6004636.98078 | 2116874.21207 | 37.792794979656 | -122.42789367737801 | (37.792794979656, -122.427893677378) | |||
| 103713 | 103713 | 96667 | DPW Maintained 3 | Magnolia grandiflora :: Southern Magnolia 21 | 1410M Mendell St | 4 | Median : Cutout 11 | Tree 1 | DPW 2 | 5 | 3x3 | 6015019.28912 | 2095450.0659 | 37.7345508055165 | -122.390472464784 | (37.7345508055165, -122.390472464784) | |||
| 114189 | 114189 | 28071 | DPW Maintained 3 | Magnolia grandiflora :: Southern Magnolia 21 | 610X Columbus Ave | 7 | Median : Cutout 11 | Tree 1 | DPW 2 | 45 | 3 | 6009783.7006387 | 2119558.1544154 | 37.800454241984404 | -122.41027530758998 | (37.8004542419844, -122.41027530759) | |||
| 121764 | 121764 | 96668 | DPW Maintained 3 | Magnolia grandiflora :: Southern Magnolia 21 | 1410M Mendell St | 5 | Median : Cutout 11 | Tree 1 | DPW 2 | 5 | 4x4 | 6015019.28912 | 2095450.0659 | 37.7345508055165 | -122.390472464784 | (37.7345508055165, -122.390472464784) | |||
| 198 | 198 | 103786 | DPW Maintained 3 | Magnolia grandiflora :: Southern Magnolia 21 | 1221 Polk St | 1 | Sidewalk: Curb side : Pot 10 | Tree 1 | DPW 2 | 11/01/2009 12:00:00 AM | 3 | 3x3 | 6006804.9894 | 2115120.2532 | 37.7881014522033 | -122.420267712778 | (37.7881014522033, -122.420267712778) | ||
| 6300 | 6300 | 103795 | Permitted Site 1 | Magnolia grandiflora :: Southern Magnolia 21 | 1215 Polk St | 1 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 11/01/2009 12:00:00 AM | 3 | 3x3 | 6006811.4062 | 2115079.7468 | 37.78799059318229 | -122.42024263571899 | (37.7879905931823, -122.420242635719) | ||
| 7553 | 7553 | 142835 | Undocumented 2 | Magnolia grandiflora :: Southern Magnolia 21 | 1515 POLK ST | 1 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | Width 0ft | 6006663.5874 | 2116129.9342 | 37.7908658176323 | -122.42082865045799 | (37.7908658176323, -122.420828650458) | ||||
| 24580 | 24580 | 130549 | Undocumented 2 | Magnolia grandiflora :: Southern Magnolia 21 | 341 Maple St | 2 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 10 | Width 2ft | 5996655.62034 | 2115093.6524799997 | 37.7874512898863 | -122.455380640001 | (37.7874512898863, -122.455380640001) | |||
| 29025 | 29025 | 130878 | Undocumented 2 | Magnolia grandiflora :: Southern Magnolia 21 | 1160 Polk St | 3 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 3 | Width 4ft | 6006883.37994 | 2114899.5545099997 | 37.7874998847581 | -122.419980826847 | (37.7874998847581, -122.419980826847) | |||
| 29646 | 29646 | 229482 | Undocumented 2 | Magnolia grandiflora :: Southern Magnolia 21 | 1557 Church St | 1 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 3 | Width 4ft | 6004608.55119 | 2099805.21218 | 37.745926022487104 | -122.426775926168 | (37.7459260224871, -122.426775926168) | |||
| 33455 | 33455 | 229568 | Undocumented 2 | Magnolia grandiflora :: Southern Magnolia 21 | 120 Parnassus Ave | 2 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 8 | Width 4ft | 5997906.00205 | 2106832.18299 | 37.7648391005609 | -122.450458797056 | (37.7648391005609, -122.450458797056) | |||
| 36081 | 36081 | 130608 | Undocumented 2 | Magnolia grandiflora :: Southern Magnolia 21 | 3730 Webster St | 2 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 11 | Width 3ft | 6002569.200540001 | 2121458.63125 | 37.8052654036378 | -122.435376365035 | (37.8052654036378, -122.435376365035) | |||
| 37713 | 37713 | 192997 | Undocumented 2 | Magnolia grandiflora :: Southern Magnolia 21 | 1856 Illinois St | 1 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 5 | Width 6ft | 6016261.5851 | 2100510.3314 | 37.748514099551 | -122.38653011709499 | (37.748514099551, -122.386530117095) | |||
| 42846 | 42846 | 130869 | Undocumented 2 | Magnolia grandiflora :: Southern Magnolia 21 | 1234 Polk St | 3 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 3 | Width 4ft | 6006839.3208099995 | 2115241.49926 | 37.78843629844079 | -122.420157540061 | (37.7884362984408, -122.420157540061) | |||
| 47018 | 47018 | 130550 | Undocumented 2 | Magnolia grandiflora :: Southern Magnolia 21 | 343 Maple St | 1 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 16 | Width 2ft | 5996664.48629 | 2115056.6733 | 37.7873502636553 | -122.45534729226699 | (37.7873502636553, -122.455347292267) | |||
| 51492 | 51492 | 142851 | Undocumented 2 | Magnolia grandiflora :: Southern Magnolia 21 | 1234 POLK ST | 1 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 2 | Width 0ft | 6006841.0842 | 2115206.4797 | 37.7883402427205 | -122.42014895267799 | (37.7883402427205, -122.420148952678) | |||
| 59110 | 59110 | 93913 | Permitted Site 1 | Magnolia grandiflora :: Southern Magnolia 21 | 1233 Polk St | 1 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 04/26/2010 12:00:00 AM | 3 | Permit Number 53384 | 6006791.18319 | 2115201.26263 | 37.7883231061636 | -122.42032123196002 | (37.7883231061636, -122.42032123196) | ||
| 69950 | 69950 | 229523 | Undocumented 2 | Magnolia grandiflora :: Southern Magnolia 21 | 1440 Church St | 1 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 4 | Width 3ft | 6004506.72479 | 2100520.4024 | 37.7478840120346 | -122.427178961864 | (37.7478840120346, -122.427178961864) | |||
| 72892 | 72892 | 142872 | Undocumented 2 | Magnolia grandiflora :: Southern Magnolia 21 | 1150 POLK ST | 2 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 2 | Width 0ft | 6006886.8043 | 2114875.2095 | 37.7874332322751 | -122.419967250965 | (37.7874332322751, -122.419967250965) | |||
| 75271 | 75271 | 143245 | Undocumented 2 | Magnolia grandiflora :: Southern Magnolia 21 | 1318 POLK ST | 1 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 2 | Width 0ft | 6006800.7783 | 2115488.2198 | 37.7891115604052 | -122.420308409442 | (37.7891115604052, -122.420308409442) | |||
| 87768 | 87768 | 113227 | Permitted Site 1 | Magnolia grandiflora :: Southern Magnolia 21 | 1150 Polk St | 2 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 3x3 | 6006889.32859586 | 2114873.18984569 | 37.7874278290173 | -122.419958374025 | (37.7874278290173, -122.419958374025) | ||||
| 119854 | 119854 | 58338 | Permitted Site 1 | Magnolia grandiflora :: Southern Magnolia 21 | 1150 Polk St | 1 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 11/07/1978 12:00:00 AM | 3x3 | Permit Number 17363 | 6006889.32859586 | 2114873.18984569 | 37.7874278290173 | -122.419958374025 | (37.7874278290173, -122.419958374025) | ||
| 127244 | 127244 | 113228 | Permitted Site 1 | Magnolia grandiflora :: Southern Magnolia 21 | 1150 Polk St | 3 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 3x3 | 6006889.32859586 | 2114873.18984569 | 37.7874278290173 | -122.419958374025 | (37.7874278290173, -122.419958374025) | ||||
| 130034 | 130034 | 142873 | Undocumented 2 | Magnolia grandiflora :: Southern Magnolia 21 | 1160 POLK ST | 1 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 2 | Width 0ft | 6006883.5959 | 2114895.6633 | 37.787489212619704 | -122.419979803427 | (37.7874892126197, -122.419979803427) | |||
| 130036 | 130036 | 229540 | Undocumented 2 | Magnolia grandiflora :: Southern Magnolia 21 | 1325 Sanchez St | 1 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 7 | Width 4ft | 6003917.32751 | 2100586.05684 | 37.7480309351905 | -122.429221751202 | (37.7480309351905, -122.429221751202) | |||
| 130605 | 130605 | 138148 | Undocumented 2 | Magnolia grandiflora :: Southern Magnolia 21 | 2069 GOLDEN GATE AVE | 1 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 12 | Width 0ft | 5999690.6663 | 2111542.6435 | 37.777874815390604 | -122.444624711517 | (37.7778748153906, -122.444624711517) | |||
| 133574 | 133574 | 229567 | Undocumented 2 | Magnolia grandiflora :: Southern Magnolia 21 | 120 Parnassus Ave | 1 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 6 | Width 4ft | 5997931.94597 | 2106834.6954799998 | 37.7648474840601 | -122.450369245258 | (37.7648474840601, -122.450369245258) | |||
| 133981 | 133981 | 177348 | Undocumented 2 | Magnolia grandiflora :: Southern Magnolia 21 | 91 Delano Ave | 2 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 13 | Width 3ft | 6000539.83976 | 2092848.12332 | 37.7265926030638 | -122.440346087917 | (37.7265926030638, -122.440346087917) | |||
| 135452 | 135452 | 142853 | Undocumented 2 | Magnolia grandiflora :: Southern Magnolia 21 | 1234 POLK ST | 3 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 2 | Width 0ft | 6006836.2715 | 2115240.5693 | 37.788433573187106 | -122.42016802418699 | (37.7884335731871, -122.420168024187) | |||
| 146449 | 146449 | 142871 | Undocumented 2 | Magnolia grandiflora :: Southern Magnolia 21 | 1150 POLK ST | 1 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 2 | Width 0ft | 6006890.0127 | 2114853.9537 | 37.7873750498338 | -122.41995464158899 | (37.7873750498338, -122.419954641589) | |||
| 149497 | 149497 | 130548 | Undocumented 2 | Magnolia grandiflora :: Southern Magnolia 21 | 341 Maple St | 1 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 8 | Width 2ft | 5996653.50032 | 2115107.523 | 37.7874892529809 | -122.45538897763299 | (37.7874892529809, -122.455388977633) | |||
| 150101 | 150101 | 138667 | Undocumented 2 | Magnolia grandiflora :: Southern Magnolia 21 | 1723 LYON ST | 1 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 12 | Width 0ft | 5999540.2728 | 2114802.3723 | 37.786816604151895 | -122.445379415012 | (37.7868166041519, -122.445379415012) | |||
| 150161 | 150161 | 142882 | Undocumented 2 | Magnolia grandiflora :: Southern Magnolia 21 | 1001 POLK ST | 2 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 2 | Width 0ft | 6006903.448 | 2114407.3806 | 37.7861496266915 | -122.41987645727801 | (37.7861496266915, -122.419876457278) | |||
| 150398 | 150398 | 208602 | Undocumented 2 | Magnolia grandiflora :: Southern Magnolia 21 | 100 Edgewood Ave | 1 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 16 | Width 4ft | 5996618.83287 | 2106426.3084 | 37.7636509189712 | -122.454881430853 | (37.7636509189712, -122.454881430853) | |||
| 150512 | 150512 | 142852 | Undocumented 2 | Magnolia grandiflora :: Southern Magnolia 21 | 1234 POLK ST | 2 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 2 | Width 0ft | 6006837.8758 | 2115224.5271 | 37.7883896156555 | -122.42016133457899 | (37.7883896156555, -122.420161334579) | |||
| 151411 | 151411 | 142859 | Undocumented 2 | Magnolia grandiflora :: Southern Magnolia 21 | 1217 POLK ST | 1 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 2 | Width 0ft | 6006807.7967 | 2115100.6016 | 37.7880476519381 | -122.420256604692 | (37.7880476519381, -122.420256604692) | |||
| 157276 | 157276 | 229935 | Undocumented 2 | Magnolia grandiflora :: Southern Magnolia 21 | 1712 Castro St | 1 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 2 | Width 3ft | 6002584.86682 | 2100441.8308900003 | 37.74755940266179 | -122.43381903603901 | (37.7475594026618, -122.433819036039) | |||
| 159164 | 159164 | 113231 | Undocumented 2 | Magnolia grandiflora :: Southern Magnolia 21 | 1001 Polk St | 2 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 3 | 3x3 | 6006895.89971 | 2114421.0496799997 | 37.7861867333855 | -122.419903542741 | (37.7861867333855, -122.419903542741) | |||
| 160221 | 160221 | 130561 | Undocumented 2 | Magnolia grandiflora :: Southern Magnolia 21 | 49 Heather Ave | 1 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 7 | Width 9ft | 5997335.31934 | 2114155.38722 | 37.784914038893206 | -122.452961280243 | (37.7849140388932, -122.452961280243) | |||
| 162325 | 162325 | 130877 | Undocumented 2 | Magnolia grandiflora :: Southern Magnolia 21 | 1160 Polk St | 2 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 1 | Width 4ft | 6006887.90937 | 2114884.47076 | 37.787458723675705 | -122.419964085101 | (37.7874587236757, -122.419964085101) | |||
| 177371 | 177371 | 208620 | Undocumented 2 | Magnolia grandiflora :: Southern Magnolia 21 | 92 Allston Way | 1 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 15 | Width 4ft | 5993943.80464 | 2098648.69817 | 37.742141779624795 | -122.46356895556801 | (37.7421417796248, -122.463568955568) | |||
| 179759 | 179759 | 229561 | Undocumented 2 | Magnolia grandiflora :: Southern Magnolia 21 | 440 27th St | 1 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 14 | Width 5ft | 6003641.78703 | 2100129.18089 | 37.7467608577476 | -122.430141970769 | (37.7467608577476, -122.430141970769) | |||
| 179806 | 179806 | 130868 | Undocumented 2 | Magnolia grandiflora :: Southern Magnolia 21 | 1234 Polk St | 2 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 3 | Width 4ft | 6006843.22474 | 2115222.14553 | 37.7883833778348 | -122.42014265898199 | (37.7883833778348, -122.420142658982) | |||
| 182027 | 182027 | 130876 | Undocumented 2 | Magnolia grandiflora :: Southern Magnolia 21 | 1160 Polk St | 1 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 3 | Width 4ft | 6006890.67261 | 2114861.9276900003 | 37.7873969816278 | -122.41995292450399 | (37.7873969816278, -122.419952924504) | |||
| 184459 | 184459 | 130870 | Undocumented 2 | Magnolia grandiflora :: Southern Magnolia 21 | 1233 Polk St | 2 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 2 | Width 4ft | 6006791.4679 | 2115188.9429 | 37.7882892952665 | -122.42031937215499 | (37.7882892952665, -122.420319372155) | |||
| 185265 | 185265 | 142850 | Undocumented 2 | Magnolia grandiflora :: Southern Magnolia 21 | 1233 POLK ST | 2 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 2 | Width 0ft | 6006796.1662 | 2115183.2186 | 37.7882738424955 | -122.42030271033501 | (37.7882738424955, -122.420302710335) | |||
| 186590 | 186590 | 142889 | Undocumented 2 | Magnolia grandiflora :: Southern Magnolia 21 | 1118 POLK ST | 1 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 2 | Width 0ft | 6006903.047 | 2114753.8909 | 37.7871010363106 | -122.419902442274 | (37.7871010363106, -122.419902442274) | |||
| 187868 | 187868 | 177360 | Undocumented 2 | Magnolia grandiflora :: Southern Magnolia 21 | 229 Edinburgh St | 1 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 1 | Width 3ft | 6003864.95037 | 2092317.2930400001 | 37.7253238242224 | -122.428813475161 | (37.7253238242224, -122.428813475161) | |||
| 4921 | 4921 | 253716 | Undocumented 2 | Magnolia grandiflora :: Southern Magnolia 21 | 2959 21st Ave | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 5x15 | 5989962.0 | 2095532.0 | 37.733353897105495 | -122.477108940264 | (37.7333538971055, -122.477108940264) | ||||
| 23462 | 23462 | 130586 | Undocumented 2 | Magnolia grandiflora :: Southern Magnolia 21 | 4 Charlton Ct | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 23 | Width 4ft | 6003663.86314 | 2118487.9182599997 | 37.7971707039232 | -122.431375953045 | (37.7971707039232, -122.431375953045) | |||
| 23688 | 23688 | 208664 | Undocumented 2 | Magnolia grandiflora :: Southern Magnolia 21 | 462 Hearst Ave | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 9 | 5998358.74509 | 2094413.2873 | 37.730765747833296 | -122.44799866202699 | (37.7307657478333, -122.447998662027) | ||||
| 24160 | 24160 | 130756 | Undocumented 2 | Magnolia grandiflora :: Southern Magnolia 21 | 2692 Broadway | 14 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 9 | Width 5ft | 6000833.48042 | 2117168.28779 | 37.7933865303134 | -122.44107503251301 | (37.7933865303134, -122.441075032513) | |||
| 24436 | 24436 | 130572 | Undocumented 2 | Magnolia grandiflora :: Southern Magnolia 21 | 3100 Lyon St | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 7 | Width 10ft | 5999066.12179 | 2119437.5027099997 | 37.7995163642449 | -122.447353599888 | (37.7995163642449, -122.447353599888) | |||
| 24607 | 24607 | 193011 | Undocumented 2 | Magnolia grandiflora :: Southern Magnolia 21 | 901 Rankin St | 8 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 2 | Width 3ft | 6013575.88043 | 2097868.72965 | 37.741111776186294 | -122.395632251741 | (37.7411117761863, -122.395632251741) | |||
| 25807 | 25807 | 130768 | Undocumented 2 | Magnolia grandiflora :: Southern Magnolia 21 | 2750 Divisadero St | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 4 | Width 4ft | 6000658.4228 | 2117791.69742 | 37.795088276953294 | -122.441725504023 | (37.7950882769533, -122.441725504023) | |||
| 25948 | 25948 | 130450 | Undocumented 2 | Magnolia grandiflora :: Southern Magnolia 21 | 2800 Divisadero St | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 4 | Width 4ft | 6000641.5527099995 | 2117919.6901 | 37.7954387499501 | -122.441793067403 | (37.7954387499501, -122.441793067403) | |||
| 26191 | 26191 | 250755 | Undocumented 2 | Magnolia grandiflora :: Southern Magnolia 21 | 2930 Lake St | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 4 | Width 10ft | 5986296.61932 | 2114541.51737 | 37.78533546029529 | -122.491179523725 | (37.7853354602953, -122.491179523725) | |||
| 27275 | 27275 | 193006 | Undocumented 2 | Magnolia grandiflora :: Southern Magnolia 21 | 901 Rankin St | 3 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 2 | Width 3ft | 6013524.8010599995 | 2097799.85374 | 37.7409198159039 | -122.39580404204399 | (37.7409198159039, -122.395804042044) | |||
| 28562 | 28562 | 229931 | Undocumented 2 | Magnolia grandiflora :: Southern Magnolia 21 | 4458 24th St | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 20 | 6000237.910080001 | 2101704.07957 | 37.7508917739405 | -122.44202523368799 | (37.7508917739405, -122.442025233688) | ||||
| 29389 | 29389 | 130842 | Undocumented 2 | Magnolia grandiflora :: Southern Magnolia 21 | 2140 Pacific Ave | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 5 | Width 4ft | 6003903.22002 | 2117323.5871599996 | 37.7939873116038 | -122.430464599871 | (37.7939873116038, -122.430464599871) | |||
| 29610 | 29610 | 192980 | Undocumented 2 | Magnolia grandiflora :: Southern Magnolia 21 | 706 De Haro St | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 1 | 6012085.32121 | 2105070.03534 | 37.7608019728409 | -122.401292034298 | (37.7608019728409, -122.401292034298) | ||||
| 32198 | 32198 | 208807 | Undocumented 2 | Magnolia grandiflora :: Southern Magnolia 21 | 465 Colon Ave | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 5 | Width 3ft | 5995478.8751300005 | 2095402.0306099998 | 37.7333155569589 | -122.458026289878 | (37.7333155569589, -122.458026289878) | |||
| 32383 | 32383 | 249815 | Undocumented 2 | Magnolia grandiflora :: Southern Magnolia 21 | 1740 Kearny St | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 8 | Width 0ft | 6010857.72173 | 2120932.6485599997 | 37.8042884107407 | -122.406655661138 | (37.8042884107407, -122.406655661138) | |||
| 32399 | 32399 | 208827 | Undocumented 2 | Magnolia grandiflora :: Southern Magnolia 21 | 494 Mangels Ave | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 38 | 5998253.80109 | 2095287.4664099999 | 37.7331600372071 | -122.44842439836701 | (37.7331600372071, -122.448424398367) | ||||
| 32971 | 32971 | 177339 | Undocumented 2 | Magnolia grandiflora :: Southern Magnolia 21 | 1705 San Jose Ave | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 4 | Width 2ft | 6001481.68018 | 2094146.3747 | 37.730210885907 | -122.43718309942498 | (37.730210885907, -122.437183099425) | |||
| 33245 | 33245 | 130844 | Undocumented 2 | Magnolia grandiflora :: Southern Magnolia 21 | 2140 Pacific Ave | 4 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 4 | Width 4ft | 6003853.59975 | 2117314.84912 | 37.7939605082153 | -122.430635667118 | (37.7939605082153, -122.430635667118) | |||
| 33721 | 33721 | 208811 | Undocumented 2 | Magnolia grandiflora :: Southern Magnolia 21 | 79 Gaviota Way | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 15 | Width 3ft | 5998427.18638 | 2097182.82265 | 37.7383741454525 | -122.447961375228 | (37.7383741454525, -122.447961375228) | |||
| 33769 | 33769 | 208832 | Undocumented 2 | Magnolia grandiflora :: Southern Magnolia 21 | 442 Circular Ave | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 17 | 5999778.071280001 | 2093728.8817 | 37.7289675587946 | -122.443042710459 | (37.7289675587946, -122.443042710459) | ||||
| 35445 | 35445 | 208800 | Undocumented 2 | Magnolia grandiflora :: Southern Magnolia 21 | 110 Hernandez Ave | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 33 | Width 3ft | 5995821.571769999 | 2099589.68539 | 37.7448335134546 | -122.457144318457 | (37.7448335134546, -122.457144318457) | |||
| 35564 | 35564 | 102050 | Permitted Site 1 | Magnolia grandiflora :: Southern Magnolia 21 | 2023 Palou Ave | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 05/14/2013 12:00:00 AM | 1 | Permit Number 770150 | 6012608.45431 | 2096904.7337099998 | 37.738410985264004 | -122.398909642062 | (37.738410985264, -122.398909642062) | ||
| 36207 | 36207 | 130847 | Undocumented 2 | Magnolia grandiflora :: Southern Magnolia 21 | 2619 Octavia St | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 12 | Width 5ft | 6004415.06873 | 2118278.49005 | 37.79663821264489 | -122.42876165712299 | (37.7966382126449, -122.428761657123) | |||
| 37204 | 37204 | 124078 | Undocumented 2 | Magnolia grandiflora :: Southern Magnolia 21 | 701 Funston Ave | 6 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 10 | 5991927.57036 | 2110249.98447 | 37.773879483752395 | -122.471385513439 | (37.7738794837524, -122.471385513439) | ||||
| 37292 | 37292 | 177310 | Undocumented 2 | Magnolia grandiflora :: Southern Magnolia 21 | 8 Seminole Ave | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 11 | Width 2ft | 5999325.726559999 | 2089990.15999 | 37.7186760905062 | -122.44433792397301 | (37.7186760905062, -122.444337923973) | |||
| 38236 | 38236 | 130748 | Undocumented 2 | Magnolia grandiflora :: Southern Magnolia 21 | 2560 Divisadero St | 9 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 6 | Width 5ft | 6000753.05451 | 2117117.77983 | 37.793243267427705 | -122.44134968544701 | (37.7932432674277, -122.441349685447) | |||
| 39209 | 39209 | 130456 | Undocumented 2 | Magnolia grandiflora :: Southern Magnolia 21 | 2800 Divisadero St | 11 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 6 | Width 4ft | 6000631.42489 | 2117979.46855 | 37.7956023087551 | -122.441832403743 | (37.7956023087551, -122.441832403743) | |||
| 39795 | 39795 | 130749 | Undocumented 2 | Magnolia grandiflora :: Southern Magnolia 21 | 2560 Divisadero St | 10 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 5 | Width 5ft | 6000751.3477 | 2117126.2512 | 37.7932664303608 | -122.441356199238 | (37.7932664303608, -122.441356199238) | |||
| 41268 | 41268 | 230148 | Undocumented 2 | Magnolia grandiflora :: Southern Magnolia 21 | 709 Duboce Ave | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 2 | Width 3ft | 6002118.99271 | 2108240.3819 | 37.7689458942764 | -122.43598793911 | (37.7689458942764, -122.43598793911) | |||
| 41424 | 41424 | 124230 | Undocumented 2 | Magnolia grandiflora :: Southern Magnolia 21 | 251 Paramount Ter | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 5 | Width 2ft | 5996657.3811099995 | 2111061.58218 | 37.7763803929944 | -122.455083075411 | (37.7763803929944, -122.455083075411) | |||
| 41544 | 41544 | 130937 | Undocumented 2 | Magnolia grandiflora :: Southern Magnolia 21 | 1070 Vallejo St | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 10 | Width 5ft | 6008416.18356 | 2118655.33625 | 37.7978985774127 | -122.414943546031 | (37.7978985774127, -122.414943546031) | |||
| 42027 | 42027 | 208665 | Undocumented 2 | Magnolia grandiflora :: Southern Magnolia 21 | 477 Flood Ave | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 3 | 5997593.379930001 | 2094080.44537 | 37.729808063373 | -122.450620649818 | (37.729808063373, -122.450620649818) | ||||
| 43372 | 43372 | 208693 | Undocumented 2 | Magnolia grandiflora :: Southern Magnolia 21 | 599 Arch St | 4 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 6 | Width 10ft | 5992715.7483 | 2091102.3080400003 | 37.7213504323647 | -122.46726657121201 | (37.7213504323647, -122.467266571212) | |||
| 43668 | 43668 | 208825 | Undocumented 2 | Magnolia grandiflora :: Southern Magnolia 21 | 66 Nordhoff St | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 11 | Width 5ft | 6000457.04798 | 2095552.5950200001 | 37.73401374202329 | -122.440826213462 | (37.7340137420233, -122.440826213462) | |||
| 44136 | 44136 | 130939 | Undocumented 2 | Magnolia grandiflora :: Southern Magnolia 21 | 1059 Vallejo St | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 14 | Width 3ft | 6008473.872930001 | 2118598.50668 | 37.7977457789976 | -122.41473989993099 | (37.7977457789976, -122.414739899931) | |||
| 44462 | 44462 | 130563 | Undocumented 2 | Magnolia grandiflora :: Southern Magnolia 21 | 24 Manzanita Ave | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 6 | Width 4ft | 5997883.48214 | 2114384.50533 | 37.7855745351846 | -122.45108135094601 | (37.7855745351846, -122.451081350946) | |||
| 44793 | 44793 | 208692 | Undocumented 2 | Magnolia grandiflora :: Southern Magnolia 21 | 599 Arch St | 3 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 4 | Width 10ft | 5992715.181469999 | 2091115.28005 | 37.7213860176206 | -122.46726947330099 | (37.7213860176206, -122.467269473301) | |||
| 45889 | 45889 | 201340 | Undocumented 2 | Magnolia grandiflora :: Southern Magnolia 21 | 1 Bitting Ave | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 4 | 6012714.10336 | 2092626.0861900002 | 37.7266685912663 | -122.39824424808901 | (37.7266685912663, -122.398244248089) | ||||
| 47554 | 47554 | 208674 | Undocumented 2 | Magnolia grandiflora :: Southern Magnolia 21 | 314 Staples Ave | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 3 | Width 10ft | 5998056.32635 | 2093827.45703 | 37.7291399048635 | -122.44900198166799 | (37.7291399048635, -122.449001981668) | |||
| 48471 | 48471 | 130745 | Undocumented 2 | Magnolia grandiflora :: Southern Magnolia 21 | 2560 Divisadero St | 6 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 8 | Width 5ft | 6000755.97288 | 2117092.09991 | 37.7931729233386 | -122.44133774426201 | (37.7931729233386, -122.441337744262) | |||
| 48533 | 48533 | 208808 | Undocumented 2 | Magnolia grandiflora :: Southern Magnolia 21 | 471 Hazelwood Ave | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 2 | Width 3ft | 5995363.92535 | 2095839.64393 | 37.7345105311352 | -122.458455366341 | (37.7345105311352, -122.458455366341) | |||
| 48826 | 48826 | 130692 | Undocumented 2 | Magnolia grandiflora :: Southern Magnolia 21 | 2332 Baker St | 9 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 6 | Width 3ft | 5999785.41198 | 2116979.1687 | 37.7928075072022 | -122.444687813291 | (37.7928075072022, -122.444687813291) | |||
| 49075 | 49075 | 230206 | Undocumented 2 | Magnolia grandiflora :: Southern Magnolia 21 | 151 Saturn St | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 8 | Width 3ft | 5999736.06445 | 2105960.1340900003 | 37.762549243174 | -122.444066437521 | (37.762549243174, -122.444066437521) | |||
| 49179 | 49179 | 229542 | Undocumented 2 | Magnolia grandiflora :: Southern Magnolia 21 | 1350 Noe St | 4 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 5 | 6003207.18518 | 2100355.87493 | 37.747358682056706 | -122.431660962579 | (37.7473586820567, -122.431660962579) | ||||
| 49818 | 49818 | 192998 | Undocumented 2 | Magnolia grandiflora :: Southern Magnolia 21 | 901 Rankin St | 12 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 2 | Width 3ft | 6013640.58193 | 2097957.11926 | 37.74135807441 | -122.395414726402 | (37.74135807441, -122.395414726402) |
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");