Data source: data.sfgov.org
This data as json, CSV (advanced)
Suggested facets: qAddress, SiteOrder, DBH, PlotSize
Link | rowid ▼ | TreeID | qLegalStatus | qSpecies | qAddress | SiteOrder | qSiteInfo | PlantType | qCaretaker | qCareAssistant | PlantDate | DBH | PlotSize | PermitNotes | XCoord | YCoord | Latitude | Longitude | Location |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
17125 | 17125 | 25503 | DPW Maintained 3 | Phoenix canariensis :: Canary Island Date Palm 100 | 1900X Market St | 3 | Median : Cutout 11 | Tree 1 | DPW 2 | 04/01/1993 12:00:00 AM | 36 | 8 | 6005164.8443 | 2108651.7776 | 37.7702480498919 | -122.42548181214701 | (37.7702480498919, -122.425481812147) | ||
17149 | 17149 | 25538 | DPW Maintained 3 | Phoenix canariensis :: Canary Island Date Palm 100 | 2200X Market St | 4 | Median : Cutout 11 | Tree 1 | DPW 2 | 04/01/1993 12:00:00 AM | 36 | 20 | 6003277.964 | 2106841.2745 | 37.7651700578839 | -122.431879221699 | (37.7651700578839, -122.431879221699) | ||
17339 | 17339 | 25501 | DPW Maintained 3 | Phoenix canariensis :: Canary Island Date Palm 100 | 1900X Market St | 1 | Median : Cutout 11 | Tree 1 | DPW 2 | 04/01/1993 12:00:00 AM | 36 | 8 | 6005202.0445 | 2108688.1512 | 37.770350024818704 | -122.425355725564 | (37.7703500248187, -122.425355725564) | ||
17397 | 17397 | 25527 | DPW Maintained 3 | Phoenix canariensis :: Canary Island Date Palm 100 | 2300X Market St | 2 | Median : Cutout 11 | Tree 1 | DPW 2 | 04/01/1993 12:00:00 AM | 36 | 10 | 6002730.2479 | 2106324.2376 | 37.7637193356407 | -122.433736680672 | (37.7637193356407, -122.433736680672) | ||
17411 | 17411 | 25526 | DPW Maintained 3 | Phoenix canariensis :: Canary Island Date Palm 100 | 2300X Market St | 1 | Median : Cutout 11 | Tree 1 | DPW 2 | 04/01/1993 12:00:00 AM | 36 | 10 | 6002746.7355 | 2106338.4868 | 37.7637593960329 | -122.43368067367201 | (37.7637593960329, -122.433680673672) | ||
17621 | 17621 | 25516 | DPW Maintained 3 | Phoenix canariensis :: Canary Island Date Palm 100 | 2190X Market St | 3 | Median : Cutout 11 | Tree 1 | DPW 2 | 04/01/1993 12:00:00 AM | 36 | 10 | 6003679.0354 | 2107225.3342 | 37.7662473210814 | -122.430519419203 | (37.7662473210814, -122.430519419203) | ||
17774 | 17774 | 25504 | DPW Maintained 3 | Phoenix canariensis :: Canary Island Date Palm 100 | 1950X Market St | 4 | Median : Cutout 11 | Tree 1 | DPW 2 | 04/01/1993 12:00:00 AM | 36 | 8 | 6005007.7768 | 2108494.7101 | 37.769807904671005 | -122.42601392538499 | (37.769807904671, -122.426013925385) | ||
18199 | 18199 | 25532 | DPW Maintained 3 | Phoenix canariensis :: Canary Island Date Palm 100 | 2300X Market St | 7 | Median : Cutout 11 | Tree 1 | DPW 2 | 04/01/1993 12:00:00 AM | 36 | 10 | 6002592.5231 | 2106186.5128 | 37.7633333608706 | -122.43420318116999 | (37.7633333608706, -122.43420318117) | ||
18227 | 18227 | 25534 | DPW Maintained 3 | Phoenix canariensis :: Canary Island Date Palm 100 | 2300X Market St | 9 | Median : Cutout 11 | Tree 1 | DPW 2 | 04/01/1993 12:00:00 AM | 36 | 10 | 6002560.5766 | 2106158.8258 | 37.763255525853296 | -122.43431169398701 | (37.7632555258533, -122.434311693987) | ||
18337 | 18337 | 25498 | DPW Maintained 3 | Phoenix canariensis :: Canary Island Date Palm 100 | 1745X Market St | 3 | Median : Cutout 11 | Tree 1 | DPW 2 | 04/01/1993 12:00:00 AM | 24 | 20 | 6005901.64349 | 2109360.28288 | 37.7722350378549 | -122.422983588528 | (37.7722350378549, -122.422983588528) | ||
18754 | 18754 | 25528 | DPW Maintained 3 | Phoenix canariensis :: Canary Island Date Palm 100 | 2300X Market St | 3 | Median : Cutout 11 | Tree 1 | DPW 2 | 04/01/1993 12:00:00 AM | 36 | 10 | 6002714.6296 | 2106302.2301 | 37.7636580221412 | -122.433789126424 | (37.7636580221412, -122.433789126424) | ||
19013 | 19013 | 25540 | DPW Maintained 3 | Phoenix canariensis :: Canary Island Date Palm 100 | 2200X Market St | 6 | Median : Cutout 11 | Tree 1 | DPW 2 | 04/01/1993 12:00:00 AM | 36 | 20 | 6003208.8276 | 2106774.142 | 37.7649818088085 | -122.43211355317601 | (37.7649818088085, -122.432113553176) | ||
19415 | 19415 | 25531 | DPW Maintained 3 | Phoenix canariensis :: Canary Island Date Palm 100 | 2300X Market St | 6 | Median : Cutout 11 | Tree 1 | DPW 2 | 04/01/1993 12:00:00 AM | 36 | 10 | 6002640.0878 | 2106231.2379 | 37.763458864653295 | -122.434041867896 | (37.7634588646533, -122.434041867896) | ||
19946 | 19946 | 25514 | DPW Maintained 3 | Phoenix canariensis :: Canary Island Date Palm 100 | 2100X Market St | 1 | Median : Cutout 11 | Tree 1 | DPW 2 | 04/01/1993 12:00:00 AM | 36 | 10 | 6004037.0875 | 2107573.3112 | 37.7672230586461 | -122.429305801661 | (37.7672230586461, -122.429305801661) | ||
20060 | 20060 | 25500 | DPW Maintained 3 | Phoenix canariensis :: Canary Island Date Palm 100 | 1745X Market St | 5 | Median : Cutout 11 | Tree 1 | DPW 2 | 04/01/1993 12:00:00 AM | 24 | 20 | 6005964.12554 | 2109421.56816 | 37.7724068380339 | -122.422771813485 | (37.7724068380339, -122.422771813485) | ||
20343 | 20343 | 25533 | DPW Maintained 3 | Phoenix canariensis :: Canary Island Date Palm 100 | 2300X Market St | 8 | Median : Cutout 11 | Tree 1 | DPW 2 | 04/01/1993 12:00:00 AM | 36 | 10 | 6002574.775 | 2106170.8945 | 37.7632894694666 | -122.43426344933201 | (37.7632894694666, -122.434263449332) | ||
20414 | 20414 | 25529 | DPW Maintained 3 | Phoenix canariensis :: Canary Island Date Palm 100 | 2300X Market St | 4 | Median : Cutout 11 | Tree 1 | DPW 2 | 04/01/1993 12:00:00 AM | 36 | 10 | 6002679.8435 | 2106267.4439 | 37.7635605336875 | -122.43390695394699 | (37.7635605336875, -122.433906953947) | ||
20599 | 20599 | 25518 | DPW Maintained 3 | Phoenix canariensis :: Canary Island Date Palm 100 | 2100X Market St | 5 | Median : Cutout 11 | Tree 1 | DPW 2 | 04/01/1993 12:00:00 AM | 36 | 10 | 6003909.9867 | 2107446.2105 | 37.7668668744555 | -122.429736358347 | (37.7668668744555, -122.429736358347) | ||
20628 | 20628 | 25499 | DPW Maintained 3 | Phoenix canariensis :: Canary Island Date Palm 100 | 1745X Market St | 4 | Median : Cutout 11 | Tree 1 | DPW 2 | 04/01/1993 12:00:00 AM | 24 | 20 | 6005915.63153 | 2109374.76445 | 37.772275590069796 | -122.42293623203999 | (37.7722755900698, -122.42293623204) | ||
21187 | 21187 | 25519 | DPW Maintained 3 | Phoenix canariensis :: Canary Island Date Palm 100 | 2100X Market St | 6 | Median : Cutout 11 | Tree 1 | DPW 2 | 04/01/1993 12:00:00 AM | 36 | 10 | 6003894.4866 | 2107428.3854 | 37.7668170533219 | -122.42978869913401 | (37.7668170533219, -122.429788699134) | ||
21387 | 21387 | 25517 | DPW Maintained 3 | Phoenix canariensis :: Canary Island Date Palm 100 | 2190X Market St | 4 | Median : Cutout 11 | Tree 1 | DPW 2 | 04/01/1993 12:00:00 AM | 36 | 10 | 6003660.4353 | 2107205.9591 | 37.7661930680529 | -122.43058237071199 | (37.7661930680529, -122.430582370712) | ||
21421 | 21421 | 25497 | DPW Maintained 3 | Phoenix canariensis :: Canary Island Date Palm 100 | 1745X Market St | 2 | Median : Cutout 11 | Tree 1 | DPW 2 | 04/01/1993 12:00:00 AM | 24 | 20 | 6005883.25661 | 2109339.92737 | 37.7721781089695 | -122.42304574337099 | (37.7721781089695, -122.423045743371) | ||
21445 | 21445 | 25496 | DPW Maintained 3 | Phoenix canariensis :: Canary Island Date Palm 100 | 1745X Market St | 1 | Median : Cutout 11 | Tree 1 | DPW 2 | 04/01/1993 12:00:00 AM | 24 | 20 | 6005866.13841 | 2109325.7941099997 | 37.772138336447 | -122.42310395199499 | (37.772138336447, -122.423103951995) | ||
21723 | 21723 | 25536 | DPW Maintained 3 | Phoenix canariensis :: Canary Island Date Palm 100 | 2200X Market St | 2 | Median : Cutout 11 | Tree 1 | DPW 2 | 04/01/1993 12:00:00 AM | 36 | 20 | 6003342.0906 | 2106904.3991 | 37.7653470177984 | -122.43166193058599 | (37.7653470177984, -122.431661930586) | ||
21747 | 21747 | 25537 | DPW Maintained 3 | Phoenix canariensis :: Canary Island Date Palm 100 | 2200X Market St | 3 | Median : Cutout 11 | Tree 1 | DPW 2 | 04/01/1993 12:00:00 AM | 36 | 20 | 6003301.0095 | 2106860.3121 | 37.7652236369165 | -122.43180087233601 | (37.7652236369165, -122.431800872336) | ||
21853 | 21853 | 25535 | DPW Maintained 3 | Phoenix canariensis :: Canary Island Date Palm 100 | 2200X Market St | 1 | Median : Cutout 11 | Tree 1 | DPW 2 | 04/01/1993 12:00:00 AM | 36 | 20 | 6003362.1302 | 2106920.4307 | 37.765392172561796 | -122.431593762963 | (37.7653921725618, -122.431593762963) | ||
21915 | 21915 | 25502 | DPW Maintained 3 | Phoenix canariensis :: Canary Island Date Palm 100 | 1900X Market St | 2 | Median : Cutout 11 | Tree 1 | DPW 2 | 04/01/1993 12:00:00 AM | 36 | 8 | 6005183.0311 | 2108665.831 | 37.7702876647003 | -122.425419904307 | (37.7702876647003, -122.425419904307) | ||
21974 | 21974 | 25530 | DPW Maintained 3 | Phoenix canariensis :: Canary Island Date Palm 100 | 2300X Market St | 5 | Median : Cutout 11 | Tree 1 | DPW 2 | 04/01/1993 12:00:00 AM | 36 | 10 | 6002661.3855 | 2106250.4058 | 37.7635127037236 | -122.433969576289 | (37.7635127037236, -122.433969576289) | ||
22015 | 22015 | 25539 | DPW Maintained 3 | Phoenix canariensis :: Canary Island Date Palm 100 | 2200X Market St | 5 | Median : Cutout 11 | Tree 1 | DPW 2 | 04/01/1993 12:00:00 AM | 36 | 20 | 6003230.8711 | 2106796.1855 | 37.7650435846647 | -122.432038884515 | (37.7650435846647, -122.432038884515) | ||
22145 | 22145 | 25515 | DPW Maintained 3 | Phoenix canariensis :: Canary Island Date Palm 100 | 2100X Market St | 2 | Median : Cutout 11 | Tree 1 | DPW 2 | 04/01/1993 12:00:00 AM | 36 | 10 | 6004020.8124 | 2107556.2611 | 37.767175321793 | -122.429360878869 | (37.767175321793, -122.429360878869) | ||
84038 | 84038 | 25506 | DPW Maintained 3 | Phoenix canariensis :: Canary Island Date Palm 100 | 1998X Market St | 6 | Median : Cutout 11 | Tree 1 | DPW 2 | 04/01/1993 12:00:00 AM | 36 | 8 | 6004905.96284 | 2108444.17955 | 37.7696634052537 | -122.42636249919701 | (37.7696634052537, -122.426362499197) | ||
89820 | 89820 | 25524 | DPW Maintained 3 | Phoenix canariensis :: Canary Island Date Palm 100 | 2194X Market St | 11 | Median : Cutout 11 | Tree 1 | DPW 2 | 04/01/1993 12:00:00 AM | 36 | 10 | 6003574.351798001 | 2107172.9273566003 | 37.766097493813604 | -122.430877759148 | (37.7660974938136, -122.430877759148) | ||
94509 | 94509 | 25522 | DPW Maintained 3 | Phoenix canariensis :: Canary Island Date Palm 100 | 2194X Market St | 9 | Median : Cutout 11 | Tree 1 | DPW 2 | 04/01/1993 12:00:00 AM | 36 | 10 | 6003574.351798001 | 2107172.9273566003 | 37.766097493813604 | -122.430877759148 | (37.7660974938136, -122.430877759148) | ||
95887 | 95887 | 25507 | DPW Maintained 3 | Phoenix canariensis :: Canary Island Date Palm 100 | 1998X Market St | 7 | Median : Cutout 11 | Tree 1 | DPW 2 | 04/01/1993 12:00:00 AM | 36 | 8 | 6004905.96284 | 2108444.17955 | 37.7696634052537 | -122.42636249919701 | (37.7696634052537, -122.426362499197) | ||
97191 | 97191 | 25521 | DPW Maintained 3 | Phoenix canariensis :: Canary Island Date Palm 100 | 2194X Market St | 8 | Median : Cutout 11 | Tree 1 | DPW 2 | 04/01/1993 12:00:00 AM | 36 | 10 | 6003574.351798001 | 2107172.9273566003 | 37.766097493813604 | -122.430877759148 | (37.7660974938136, -122.430877759148) | ||
113197 | 113197 | 25505 | DPW Maintained 3 | Phoenix canariensis :: Canary Island Date Palm 100 | 1998X Market St | 5 | Median : Cutout 11 | Tree 1 | DPW 2 | 04/01/1993 12:00:00 AM | 36 | 8 | 6004905.96284 | 2108444.17955 | 37.7696634052537 | -122.42636249919701 | (37.7696634052537, -122.426362499197) | ||
121520 | 121520 | 25525 | DPW Maintained 3 | Phoenix canariensis :: Canary Island Date Palm 100 | 2194X Market St | 12 | Median : Cutout 11 | Tree 1 | DPW 2 | 04/01/1993 12:00:00 AM | 36 | 10 | 6003574.351798001 | 2107172.9273566003 | 37.766097493813604 | -122.430877759148 | (37.7660974938136, -122.430877759148) | ||
127344 | 127344 | 25523 | DPW Maintained 3 | Phoenix canariensis :: Canary Island Date Palm 100 | 2194X Market St | 10 | Median : Cutout 11 | Tree 1 | DPW 2 | 04/01/1993 12:00:00 AM | 36 | 10 | 6003574.351798001 | 2107172.9273566003 | 37.766097493813604 | -122.430877759148 | (37.7660974938136, -122.430877759148) | ||
142041 | 142041 | 25520 | DPW Maintained 3 | Phoenix canariensis :: Canary Island Date Palm 100 | 2194X Market St | 7 | Median : Cutout 11 | Tree 1 | DPW 2 | 04/01/1993 12:00:00 AM | 36 | 10 | 6003574.351798001 | 2107172.9273566003 | 37.766097493813604 | -122.430877759148 | (37.7660974938136, -122.430877759148) |
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");