Data source: data.sfgov.org
This data as json, CSV (advanced)
Suggested facets: qLegalStatus, qAddress, SiteOrder, qCaretaker, DBH, PlotSize
Link | rowid ▼ | TreeID | qLegalStatus | qSpecies | qAddress | SiteOrder | qSiteInfo | PlantType | qCaretaker | qCareAssistant | PlantDate | DBH | PlotSize | PermitNotes | XCoord | YCoord | Latitude | Longitude | Location |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
2250 | 2250 | 200335 | Permitted Site 1 | Liriodendron tulipifera :: Tulip Tree 85 | 750 Phelps St | 7 | : 4 | Tree 1 | Purchasing Dept 15 | 4 | Width 2ft | 6015505.4551 | 2098329.2709 | 37.7424834725483 | -122.388992567847 | (37.7424834725483, -122.388992567847) | |||
2256 | 2256 | 200334 | Permitted Site 1 | Liriodendron tulipifera :: Tulip Tree 85 | 750 Phelps St | 4 | : 4 | Tree 1 | Purchasing Dept 15 | 11/15/1992 12:00:00 AM | 8 | Width 3ft | 6015528.91481 | 2098358.82009 | 37.742565908900204 | -122.388913512973 | (37.7425659089002, -122.388913512973) | ||
25127 | 25127 | 200366 | Undocumented 2 | Liriodendron tulipifera :: Tulip Tree 85 | 1300 Phelps St | 8 | : 4 | Tree 1 | Private 1 | 12 | Width 5ft | 6014047.106269999 | 2096372.4575200002 | 37.7370295240776 | -122.393898196954 | (37.7370295240776, -122.393898196954) | |||
31300 | 31300 | 200349 | Undocumented 2 | Liriodendron tulipifera :: Tulip Tree 85 | 900 Phelps St | 11 | : 4 | Tree 1 | Private 1 | 8 | Width 4ft | 6014526.629869999 | 2097016.7538700001 | 37.738825266977294 | -122.392285304228 | (37.7388252669773, -122.392285304228) | |||
40723 | 40723 | 200348 | Undocumented 2 | Liriodendron tulipifera :: Tulip Tree 85 | 900 Phelps St | 10 | : 4 | Tree 1 | Private 1 | 9 | Width 4ft | 6014546.28219 | 2097041.8855599998 | 37.738895364638 | -122.39221911232599 | (37.738895364638, -122.392219112326) | |||
42998 | 42998 | 200342 | Undocumented 2 | Liriodendron tulipifera :: Tulip Tree 85 | 750 Phelps St | 25 | : 4 | Tree 1 | Private 1 | 8 | Width 2ft | 6015273.793930001 | 2098017.0765 | 37.7416134072345 | -122.389771789042 | (37.7416134072345, -122.389771789042) | |||
45529 | 45529 | 200360 | Undocumented 2 | Liriodendron tulipifera :: Tulip Tree 85 | 1150 Phelps St | 5 | : 4 | Tree 1 | Private 1 | 6 | Width 5ft | 6014196.6239 | 2096573.2462900002 | 37.737589156904995 | -122.393395290662 | (37.737589156905, -122.393395290662) | |||
46141 | 46141 | 200359 | Undocumented 2 | Liriodendron tulipifera :: Tulip Tree 85 | 1150 Phelps St | 4 | : 4 | Tree 1 | Private 1 | 9 | Width 5ft | 6014213.143619999 | 2096595.32013 | 37.737650684936796 | -122.393339717964 | (37.7376506849368, -122.393339717964) | |||
57963 | 57963 | 200352 | Undocumented 2 | Liriodendron tulipifera :: Tulip Tree 85 | 900 Phelps St | 16 | : 4 | Tree 1 | Private 1 | 14 | Width 5ft | 6014405.80816 | 2096853.92235 | 37.7383714555731 | -122.392691664697 | (37.7383714555731, -122.392691664697) | |||
63351 | 63351 | 200365 | Undocumented 2 | Liriodendron tulipifera :: Tulip Tree 85 | 1300 Phelps St | 7 | : 4 | Tree 1 | Private 1 | 6 | Width 5ft | 6014060.81183 | 2096393.5404700001 | 37.7370881751809 | -122.39385228564801 | (37.7370881751809, -122.393852285648) | |||
72490 | 72490 | 200340 | Undocumented 2 | Liriodendron tulipifera :: Tulip Tree 85 | 750 Phelps St | 23 | : 4 | Tree 1 | Private 1 | 8 | Width 2ft | 6015300.13853 | 2098052.9717 | 37.7417134289277 | -122.38968320401399 | (37.7417134289277, -122.389683204014) | |||
74895 | 74895 | 200358 | Undocumented 2 | Liriodendron tulipifera :: Tulip Tree 85 | 1150 Phelps St | 3 | : 4 | Tree 1 | Private 1 | 12 | Width 5ft | 6014239.8641 | 2096632.70057 | 37.7377548084229 | -122.393249946754 | (37.7377548084229, -122.393249946754) | |||
76523 | 76523 | 200341 | Undocumented 2 | Liriodendron tulipifera :: Tulip Tree 85 | 750 Phelps St | 24 | : 4 | Tree 1 | Private 1 | 8 | Width 2ft | 6015282.07626 | 2098027.6206799997 | 37.74164281866221 | -122.389743887597 | (37.7416428186622, -122.389743887597) | |||
105063 | 105063 | 200347 | Undocumented 2 | Liriodendron tulipifera :: Tulip Tree 85 | 900 Phelps St | 9 | : 4 | Tree 1 | Private 1 | 11 | Width 4ft | 6014556.031830001 | 2097054.78425 | 37.7389313231291 | -122.392186304173 | (37.7389313231291, -122.392186304173) | |||
112760 | 112760 | 200367 | Undocumented 2 | Liriodendron tulipifera :: Tulip Tree 85 | 1300 Phelps St | 9 | : 4 | Tree 1 | Private 1 | 17 | Width 5ft | 6014030.85339 | 2096351.6806400002 | 37.7369715717905 | -122.393952936896 | (37.7369715717905, -122.393952936896) | |||
133126 | 133126 | 200353 | Undocumented 2 | Liriodendron tulipifera :: Tulip Tree 85 | 900 Phelps St | 17 | : 4 | Tree 1 | Private 1 | 11 | Width 5ft | 6014392.43301 | 2096834.63166 | 37.738317744462 | -122.392736560653 | (37.738317744462, -122.392736560653) | |||
134636 | 134636 | 200355 | Undocumented 2 | Liriodendron tulipifera :: Tulip Tree 85 | 900 Phelps St | 19 | : 4 | Tree 1 | Private 1 | 11 | Width 5ft | 6014345.08354 | 2096773.3910700001 | 37.7381469605042 | -122.392895989784 | (37.7381469605042, -122.392895989784) | |||
137367 | 137367 | 200339 | Undocumented 2 | Liriodendron tulipifera :: Tulip Tree 85 | 750 Phelps St | 22 | : 4 | Tree 1 | Private 1 | 5 | Width 2ft | 6015308.33502 | 2098065.1650799997 | 37.741747363937606 | -122.389655714464 | (37.7417473639376, -122.389655714464) | |||
146537 | 146537 | 200350 | Undocumented 2 | Liriodendron tulipifera :: Tulip Tree 85 | 900 Phelps St | 12 | : 4 | Tree 1 | Private 1 | 7 | Width 4ft | 6014508.81125 | 2096991.75117 | 37.738755625282394 | -122.39234516490299 | (37.7387556252824, -122.392345164903) | |||
151751 | 151751 | 200344 | Undocumented 2 | Liriodendron tulipifera :: Tulip Tree 85 | 750 Phelps St | 40 | : 4 | Tree 1 | Private 1 | 4 | Width 4ft | 6015132.05324 | 2097828.30985 | 37.74108723188171 | -122.390248699517 | (37.7410872318817, -122.390248699517) | |||
157215 | 157215 | 200364 | Undocumented 2 | Liriodendron tulipifera :: Tulip Tree 85 | 1300 Phelps St | 6 | : 4 | Tree 1 | Private 1 | 13 | Width 5ft | 6014077.799769999 | 2096412.7772 | 37.7371419393345 | -122.393794896313 | (37.7371419393345, -122.393794896313) | |||
159507 | 159507 | 200343 | Undocumented 2 | Liriodendron tulipifera :: Tulip Tree 85 | 750 Phelps St | 39 | : 4 | Tree 1 | Private 1 | 8 | Width 4ft | 6015141.18947 | 2097840.20057 | 37.741120388109294 | -122.39021794000799 | (37.7411203881093, -122.390217940008) | |||
160126 | 160126 | 200338 | Undocumented 2 | Liriodendron tulipifera :: Tulip Tree 85 | 750 Phelps St | 21 | : 4 | Tree 1 | Private 1 | 9 | Width 2ft | 6015318.39191 | 2098076.99567 | 37.7417804059521 | -122.389621766852 | (37.7417804059521, -122.389621766852) | |||
166431 | 166431 | 200336 | Undocumented 2 | Liriodendron tulipifera :: Tulip Tree 85 | 750 Phelps St | 8 | : 4 | Tree 1 | Private 1 | 9 | Width 3ft | 6015493.51667 | 2098314.62088 | 37.7424425848476 | -122.38903282511002 | (37.7424425848476, -122.38903282511) | |||
167176 | 167176 | 200363 | Undocumented 2 | Liriodendron tulipifera :: Tulip Tree 85 | 1300 Phelps St | 5 | : 4 | Tree 1 | Private 1 | 8 | Width 5ft | 6014137.38405 | 2096492.6896799998 | 37.7373646735385 | -122.393594476122 | (37.7373646735385, -122.393594476122) | |||
168594 | 168594 | 200346 | Undocumented 2 | Liriodendron tulipifera :: Tulip Tree 85 | 900 Phelps St | 4 | : 4 | Tree 1 | Private 1 | 9 | Width 4ft | 6014640.20968 | 2097167.32462 | 37.7392450093596 | -122.391903121137 | (37.7392450093596, -122.391903121137) | |||
169282 | 169282 | 200361 | Undocumented 2 | Liriodendron tulipifera :: Tulip Tree 85 | 1300 Phelps St | 1 | : 4 | Tree 1 | Private 1 | 7 | Width 5ft | 6014182.02229 | 2096553.32448 | 37.7375336444497 | -122.39344438196699 | (37.7375336444497, -122.393444381967) | |||
175699 | 175699 | 200345 | Undocumented 2 | Liriodendron tulipifera :: Tulip Tree 85 | 900 Phelps St | 3 | : 4 | Tree 1 | Private 1 | 6 | Width 4ft | 6014658.54117 | 2097192.95407 | 37.7393164002222 | -122.391841530176 | (37.7393164002222, -122.391841530176) | |||
185785 | 185785 | 200337 | Undocumented 2 | Liriodendron tulipifera :: Tulip Tree 85 | 750 Phelps St | 9 | : 4 | Tree 1 | Private 1 | 10 | Width 4ft | 6015484.2575199995 | 2098301.13552 | 37.742405043569796 | -122.389063899405 | (37.7424050435698, -122.389063899405) | |||
186583 | 186583 | 200362 | Undocumented 2 | Liriodendron tulipifera :: Tulip Tree 85 | 1300 Phelps St | 3 | : 4 | Tree 1 | Private 1 | 7 | Width 5ft | 6014166.7855 | 2096532.27247 | 37.7374749933851 | -122.39349559025801 | (37.7374749933851, -122.393495590258) |
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");