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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
1950 | 1950 | 252823 | Significant Tree 6 | Maytenus boaria :: Mayten 22 | 3852 17th St | 2 | Front Yard : Yard 7 | Tree 1 | Private 1 | 6003330.0 | 2106021.0 | 37.7629207320267 | -122.43164067381399 | (37.7629207320267, -122.431640673814) | |||||
7171 | 7171 | 9447 | Permitted Site 1 | Maytenus boaria :: Mayten 22 | 800X Golden Gate Ave | 3 | Front Yard : Yard 7 | Tree 1 | Rec/Park 3 | 12 | 3X3 | 6005622.1957 | 2112431.3933 | 37.780651788182794 | -122.424168675479 | (37.7806517881828, -122.424168675479) | |||
7570 | 7570 | 9448 | Permitted Site 1 | Maytenus boaria :: Mayten 22 | 800X Golden Gate Ave | 4 | Front Yard : Yard 7 | Tree 1 | Rec/Park 3 | 05/18/1992 12:00:00 AM | 12 | 3X3 | 6005590.2441 | 2112426.5193 | 37.78063660125729 | -122.424278864743 | (37.7806366012573, -122.424278864743) | ||
7740 | 7740 | 9445 | Permitted Site 1 | Maytenus boaria :: Mayten 22 | 800X Golden Gate Ave | 1 | Front Yard : Yard 7 | Tree 1 | Rec/Park 3 | 03/01/1994 12:00:00 AM | 12 | 3X3 | 6005680.1419 | 2112439.5166 | 37.780677364386705 | -122.423968789396 | (37.7806773643867, -122.423968789396) | ||
8920 | 8920 | 9449 | Permitted Site 1 | Maytenus boaria :: Mayten 22 | 800X Golden Gate Ave | 5 | Front Yard : Yard 7 | Tree 1 | Rec/Park 3 | 12 | 3X3 | 6005556.1262 | 2112420.5622 | 37.780618317973 | -122.424396471178 | (37.780618317973, -122.424396471178) | |||
20865 | 20865 | 103256 | Significant Tree 6 | Maytenus boaria :: Mayten 22 | 4187 26th St | 1 | Front Yard : Yard 7 | Tree 1 | Private 1 | 16 | 3x3 | 6002700.0 | 2100625.0 | 37.7480688746475 | -122.433434000346 | (37.7480688746475, -122.433434000346) | |||
27829 | 27829 | 193480 | Undocumented 2 | Maytenus boaria :: Mayten 22 | 1301 Minnesota St | 57 | Front Yard : Yard 7 | Tree 1 | Private 1 | 3 | 6015360.9836800005 | 2102396.38137 | 37.7536428990178 | -122.389776125583 | (37.7536428990178, -122.389776125583) | ||||
30162 | 30162 | 193481 | Undocumented 2 | Maytenus boaria :: Mayten 22 | 1301 Minnesota St | 58 | Front Yard : Yard 7 | Tree 1 | Private 1 | 4 | 6015360.43842 | 2102393.9251099997 | 37.753636124410896 | -122.389777839677 | (37.7536361244109, -122.389777839677) | ||||
31972 | 31972 | 249967 | Undocumented 2 | Maytenus boaria :: Mayten 22 | 265 Filbert St | 4 | Front Yard : Yard 7 | Tree 1 | Private 1 | 11 | Width 0ft | 6011605.44865 | 2120090.74048 | 37.8020185425817 | -122.404008793573 | (37.8020185425817, -122.404008793573) | |||
32077 | 32077 | 231557 | Undocumented 2 | Maytenus boaria :: Mayten 22 | 1001 San Jose Ave | 43 | Front Yard : Yard 7 | Tree 1 | Private 1 | 1 | 6005302.15218 | 2097157.06832 | 37.738694011804796 | -122.424189245746 | (37.7386940118048, -122.424189245746) | ||||
36758 | 36758 | 193478 | Undocumented 2 | Maytenus boaria :: Mayten 22 | 1301 Minnesota St | 22 | Front Yard : Yard 7 | Tree 1 | Private 1 | 7 | 6015377.93979 | 2102408.26653 | 37.7536764734156 | -122.389718317152 | (37.7536764734156, -122.389718317152) | ||||
36892 | 36892 | 193483 | Undocumented 2 | Maytenus boaria :: Mayten 22 | 1301 Minnesota St | 60 | Front Yard : Yard 7 | Tree 1 | Private 1 | 5 | 6015357.60434 | 2102388.55358 | 37.753621218165605 | -122.38978726547501 | (37.7536212181656, -122.389787265475) | ||||
39311 | 39311 | 193482 | Undocumented 2 | Maytenus boaria :: Mayten 22 | 1301 Minnesota St | 59 | Front Yard : Yard 7 | Tree 1 | Private 1 | 7 | 6015356.53951 | 2102391.04268 | 37.7536279936584 | -122.38979112177 | (37.7536279936584, -122.38979112177) | ||||
46214 | 46214 | 249735 | Undocumented 2 | Maytenus boaria :: Mayten 22 | 2500 Broderick St | 19 | Front Yard : Yard 7 | Tree 1 | Private 1 | 10 | 6000198.719930001 | 2117216.42615 | 37.7934825302438 | -122.443274802094 | (37.7934825302438, -122.443274802094) | ||||
47701 | 47701 | 249727 | Undocumented 2 | Maytenus boaria :: Mayten 22 | 2500 Broderick St | 11 | Front Yard : Yard 7 | Tree 1 | Private 1 | 10 | 6000218.44673 | 2117239.64543 | 37.7935474091368 | -122.44320821449101 | (37.7935474091368, -122.443208214491) | ||||
49586 | 49586 | 249962 | Undocumented 2 | Maytenus boaria :: Mayten 22 | 271 Filbert St | 2 | Front Yard : Yard 7 | Tree 1 | Private 1 | 15 | Width 0ft | 6011589.39853 | 2120084.6088 | 37.802000809738296 | -122.40406390314301 | (37.8020008097383, -122.404063903143) | |||
51851 | 51851 | 248038 | Undocumented 2 | Maytenus boaria :: Mayten 22 | 55 Rutledge St | 2 | Front Yard : Yard 7 | Tree 1 | Private 1 | 3 | 6010483.83611 | 2099425.5647299998 | 37.7452140265169 | -122.40643314998002 | (37.7452140265169, -122.40643314998) | ||||
61451 | 61451 | 231561 | Undocumented 2 | Maytenus boaria :: Mayten 22 | 1201 San Jose Ave | 21 | Front Yard : Yard 7 | Tree 1 | Private 1 | 7 | 6004334.17672 | 2095933.6813700001 | 37.7352801655395 | -122.427448917631 | (37.7352801655395, -122.427448917631) | ||||
63019 | 63019 | 193492 | Undocumented 2 | Maytenus boaria :: Mayten 22 | 1918 23rd St | 1 | Front Yard : Yard 7 | Tree 1 | Private 1 | 9 | 6012632.36685 | 2102863.5529 | 37.754773961059705 | -122.399245141377 | (37.7547739610597, -122.399245141377) | ||||
64803 | 64803 | 231121 | Undocumented 2 | Maytenus boaria :: Mayten 22 | 190 Storrie St | 2 | Front Yard : Yard 7 | Tree 1 | Private 1 | 8 | Width 3ft | 6000723.30241 | 2105266.47257 | 37.76070088814579 | -122.44060219326 | (37.7607008881458, -122.44060219326) | |||
74113 | 74113 | 249819 | Undocumented 2 | Maytenus boaria :: Mayten 22 | 275 Kearny St | 1 | Front Yard : Yard 7 | Tree 1 | Private 1 | 16 | Width 0ft | 6010904.45886 | 2120604.70215 | 37.803390565377605 | -122.40647080008002 | (37.8033905653776, -122.40647080008) | |||
79494 | 79494 | 105555 | Significant Tree 6 | Maytenus boaria :: Mayten 22 | 410 Elizabeth St | 2 | Front Yard : Yard 7 | Tree 1 | Private 1 | Permit Number 772516 | 6003623.1 | 2102191.9 | 37.7524235434098 | -122.430353733326 | (37.7524235434098, -122.430353733326) | ||||
88320 | 88320 | 105866 | Significant Tree 6 | Maytenus boaria :: Mayten 22 | 3555 Cesar Chavez St | 1 | Front Yard : Yard 7 | Tree 1 | Private 1 | 6006336.4 | 2100501.8 | 37.7479362343406 | -122.420850697466 | (37.7479362343406, -122.420850697466) | |||||
92493 | 92493 | 112481 | Significant Tree 6 | Maytenus boaria :: Mayten 22 | 1275 Columbus Ave | 1 | Front Yard : Yard 7 | Tree 1 | Private 1 | 08/03/2015 12:00:00 AM | 6007539.6 | 2121483.9 | 37.8056158049656 | -122.418177422209 | (37.8056158049656, -122.418177422209) | ||||
107936 | 107936 | 118318 | Property Tree 7 | Maytenus boaria :: Mayten 22 | 20 Norton St | 1 | Front Yard : Yard 7 | Tree 1 | MTA 6 | 6002015.686319999 | 2092167.12899 | 37.724806667280895 | -122.435195459751 | (37.7248066672809, -122.435195459751) | |||||
126305 | 126305 | 105554 | Significant Tree 6 | Maytenus boaria :: Mayten 22 | 410 Elizabeth St | 1 | Front Yard : Yard 7 | Tree 1 | Private 1 | Permit Number 772516 | 6003623.1 | 2102191.9 | 37.7524235434098 | -122.430353733326 | (37.7524235434098, -122.430353733326) | ||||
131494 | 131494 | 249728 | Undocumented 2 | Maytenus boaria :: Mayten 22 | 2500 Broderick St | 12 | Front Yard : Yard 7 | Tree 1 | Private 1 | 10 | 6000179.512490001 | 2117293.73035 | 37.7936936919486 | -122.44334681623 | (37.7936936919486, -122.44334681623) | ||||
147577 | 147577 | 247965 | Undocumented 2 | Maytenus boaria :: Mayten 22 | 16 Joy St | 1 | Front Yard : Yard 7 | Tree 1 | Private 1 | 4 | 6010335.67136 | 2098911.58269 | 37.7437944538456 | -122.40690926186599 | (37.7437944538456, -122.406909261866) | ||||
148533 | 148533 | 193479 | Undocumented 2 | Maytenus boaria :: Mayten 22 | 1301 Minnesota St | 56 | Front Yard : Yard 7 | Tree 1 | Private 1 | 3 | 6015359.30963 | 2102399.3763599996 | 37.7536510297943 | -122.38978212404601 | (37.7536510297943, -122.389782124046) | ||||
154759 | 154759 | 247966 | Undocumented 2 | Maytenus boaria :: Mayten 22 | 16 Joy St | 2 | Front Yard : Yard 7 | Tree 1 | Private 1 | 3 | 6010335.18608 | 2098918.4382599997 | 37.7438132505971 | -122.406911422945 | (37.7438132505971, -122.406911422945) | ||||
155704 | 155704 | 231558 | Undocumented 2 | Maytenus boaria :: Mayten 22 | 1001 San Jose Ave | 44 | Front Yard : Yard 7 | Tree 1 | Private 1 | 1 | 6005302.642109999 | 2097155.21655 | 37.738688954924605 | -122.424187420138 | (37.7386889549246, -122.424187420138) | ||||
159004 | 159004 | 249741 | Undocumented 2 | Maytenus boaria :: Mayten 22 | 2500 Broderick St | 25 | Front Yard : Yard 7 | Tree 1 | Private 1 | 14 | 6000213.465969999 | 2117180.10756 | 37.7933836497995 | -122.443221170114 | (37.7933836497995, -122.443221170114) | ||||
163281 | 163281 | 231560 | Undocumented 2 | Maytenus boaria :: Mayten 22 | 1001 San Jose Ave | 47 | Front Yard : Yard 7 | Tree 1 | Private 1 | 7 | 6005307.33696 | 2097165.86428 | 37.7387184562788 | -122.424171944599 | (37.7387184562788, -122.424171944599) | ||||
167941 | 167941 | 209382 | Undocumented 2 | Maytenus boaria :: Mayten 22 | 900 Lawton St | 1 | Front Yard : Yard 7 | Tree 1 | Private 1 | 14 | 5991530.80224 | 2104909.87583 | 37.7591940156155 | -122.472368615844 | (37.7591940156155, -122.472368615844) | ||||
169723 | 169723 | 247968 | Undocumented 2 | Maytenus boaria :: Mayten 22 | 16 Joy St | 4 | Front Yard : Yard 7 | Tree 1 | Private 1 | 3 | 6010328.07842 | 2098922.3169299997 | 37.743823502860295 | -122.406936272997 | (37.7438235028603, -122.406936272997) | ||||
170652 | 170652 | 249730 | Undocumented 2 | Maytenus boaria :: Mayten 22 | 2500 Broderick St | 14 | Front Yard : Yard 7 | Tree 1 | Private 1 | 8 | 6000189.62639 | 2117273.3619 | 37.7936383422859 | -122.443310357702 | (37.7936383422859, -122.443310357702) | ||||
171349 | 171349 | 249726 | Undocumented 2 | Maytenus boaria :: Mayten 22 | 2500 Broderick St | 10 | Front Yard : Yard 7 | Tree 1 | Private 1 | 12 | 6000203.6914 | 2117248.8827299997 | 37.793571930958706 | -122.44325993272301 | (37.7935719309587, -122.443259932723) | ||||
172949 | 172949 | 231559 | Undocumented 2 | Maytenus boaria :: Mayten 22 | 1001 San Jose Ave | 45 | Front Yard : Yard 7 | Tree 1 | Private 1 | 1 | 6005304.59502 | 2097156.92605 | 37.738693759094296 | -122.424180789438 | (37.7386937590943, -122.424180789438) | ||||
176179 | 176179 | 193493 | Undocumented 2 | Maytenus boaria :: Mayten 22 | 1920 23rd St | 1 | Front Yard : Yard 7 | Tree 1 | Private 1 | 7 | 6012617.15977 | 2102863.30837 | 37.7547724421095 | -122.399297714811 | (37.7547724421095, -122.399297714811) | ||||
176995 | 176995 | 249729 | Undocumented 2 | Maytenus boaria :: Mayten 22 | 2500 Broderick St | 13 | Front Yard : Yard 7 | Tree 1 | Private 1 | 13 | 6000196.56443 | 2117292.56753 | 37.7936914715225 | -122.44328773166201 | (37.7936914715225, -122.443287731662) | ||||
187463 | 187463 | 249725 | Undocumented 2 | Maytenus boaria :: Mayten 22 | 2500 Broderick St | 9 | Front Yard : Yard 7 | Tree 1 | Private 1 | 11 | 6000213.93335 | 2117265.22883 | 37.793617397063606 | -122.44322566942301 | (37.7936173970636, -122.443225669423) |
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");