Data source: data.sfgov.org
This data as json, CSV (advanced)
Suggested facets: qLegalStatus, SiteOrder, qCaretaker, PlantDate, DBH, PlotSize
Link | rowid ▼ | TreeID | qLegalStatus | qSpecies | qAddress | SiteOrder | qSiteInfo | PlantType | qCaretaker | qCareAssistant | PlantDate | DBH | PlotSize | PermitNotes | XCoord | YCoord | Latitude | Longitude | Location |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
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) |
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");