Data source: data.sfgov.org
This data as json, CSV (advanced)
Suggested facets: qLegalStatus, qAddress, SiteOrder, DBH, PlotSize
Link | rowid ▼ | TreeID | qLegalStatus | qSpecies | qAddress | SiteOrder | qSiteInfo | PlantType | qCaretaker | qCareAssistant | PlantDate | DBH | PlotSize | PermitNotes | XCoord | YCoord | Latitude | Longitude | Location |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
27666 | 27666 | 183543 | Undocumented 2 | Arbutus unedo :: Strawberry Tree 61 | 2581 25th Ave | 2 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 6 | Width 0ft | 5988605.1751 | 2097774.8752 | 37.7394334392266 | -122.481964049119 | (37.7394334392266, -122.481964049119) | |||
28228 | 28228 | 205559 | Undocumented 2 | Arbutus unedo :: Strawberry Tree 61 | 24 Merced Ave | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 4 | Width 3ft | 5995247.107919999 | 2100152.69765 | 37.74634639618 | -122.45917145420601 | (37.74634639618, -122.459171454206) | |||
29030 | 29030 | 205556 | Undocumented 2 | Arbutus unedo :: Strawberry Tree 61 | 40 Merced Ave | 2 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 5 | Width 3ft | 5995160.10892 | 2100068.40682 | 37.746109952717 | -122.45946618093299 | (37.746109952717, -122.459466180933) | |||
31054 | 31054 | 205576 | Undocumented 2 | Arbutus unedo :: Strawberry Tree 61 | 120 Santa Paula Ave | 3 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 3 | Width 3ft | 5993987.58227 | 2096991.7389900002 | 37.737594705717896 | -122.463297378285 | (37.7375947057179, -122.463297378285) | |||
36456 | 36456 | 205583 | Undocumented 2 | Arbutus unedo :: Strawberry Tree 61 | 150 Santa Paula Ave | 7 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 5 | Width 3ft | 5994004.16046 | 2096866.7723599998 | 37.737252533472706 | -122.46323099482001 | (37.7372525334727, -122.46323099482) | |||
39814 | 39814 | 205577 | Undocumented 2 | Arbutus unedo :: Strawberry Tree 61 | 150 Santa Paula Ave | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 2 | Width 3ft | 5993988.87344 | 2096971.5680200001 | 37.737539395633604 | -122.46329145086099 | (37.7375393956336, -122.463291450861) | |||
41519 | 41519 | 204289 | Undocumented 2 | Arbutus unedo :: Strawberry Tree 61 | 1723 12th Ave | 3 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 9 | Width 3ft | 5992459.80825 | 2103811.38116 | 37.7562315606514 | -122.46907574904499 | (37.7562315606514, -122.469075749045) | |||
43651 | 43651 | 204244 | Undocumented 2 | Arbutus unedo :: Strawberry Tree 61 | 621 Laguna Honda Blvd | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 4 | Width 4ft | 5995706.46368 | 2099903.31697 | 37.7456880564513 | -122.45756502581301 | (37.7456880564513, -122.457565025813) | |||
44018 | 44018 | 205537 | Undocumented 2 | Arbutus unedo :: Strawberry Tree 61 | 351 Montecito Ave | 3 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 14 | Width 3ft | 5995962.698480001 | 2094090.23289 | 37.7297414640913 | -122.45625877314698 | (37.7297414640913, -122.456258773147) | |||
44816 | 44816 | 205558 | Undocumented 2 | Arbutus unedo :: Strawberry Tree 61 | 24 Merced Ave | 2 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 4 | Width 3ft | 5995231.87418 | 2100136.53584 | 37.7463011440963 | -122.459222960193 | (37.7463011440963, -122.459222960193) | |||
48243 | 48243 | 205579 | Undocumented 2 | Arbutus unedo :: Strawberry Tree 61 | 150 Santa Paula Ave | 3 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 2 | Width 3ft | 5993994.26166 | 2096934.2401 | 37.737437212859795 | -122.463270113518 | (37.7374372128598, -122.463270113518) | |||
52394 | 52394 | 204288 | Undocumented 2 | Arbutus unedo :: Strawberry Tree 61 | 1723 12th Ave | 4 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 6 | Width 3ft | 5992460.26987 | 2103777.38754 | 37.7561382497077 | -122.46907167872801 | (37.7561382497077, -122.469071678728) | |||
53802 | 53802 | 205582 | Undocumented 2 | Arbutus unedo :: Strawberry Tree 61 | 150 Santa Paula Ave | 6 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 5 | Width 3ft | 5994001.091440001 | 2096883.9077299999 | 37.7372994061387 | -122.463242848772 | (37.7372994061387, -122.463242848772) | |||
53893 | 53893 | 205569 | Undocumented 2 | Arbutus unedo :: Strawberry Tree 61 | 100 Santa Monica Way | 2 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 9 | Width 3ft | 5993966.5050099995 | 2097132.29462 | 37.737979422216604 | -122.46338044867201 | (37.7379794222166, -122.463380448672) | |||
55600 | 55600 | 205571 | Undocumented 2 | Arbutus unedo :: Strawberry Tree 61 | 114 Santa Paula Ave | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 8 | Width 3ft | 5993972.11 | 2097104.0492 | 37.7379021902407 | -122.463359020507 | (37.7379021902407, -122.463359020507) | |||
66902 | 66902 | 205581 | Undocumented 2 | Arbutus unedo :: Strawberry Tree 61 | 150 Santa Paula Ave | 5 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 2 | Width 3ft | 5993999.7716 | 2096902.7135 | 37.737350966076 | -122.46324877623199 | (37.737350966076, -122.463248776232) | |||
67082 | 67082 | 204282 | Undocumented 2 | Arbutus unedo :: Strawberry Tree 61 | 855 Ortega St | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 9 | Width 3ft | 5991318.4935 | 2102451.26095 | 37.75243101579329 | -122.472923591054 | (37.7524310157933, -122.472923591054) | |||
67242 | 67242 | 246811 | Undocumented 2 | Arbutus unedo :: Strawberry Tree 61 | 161 Brewster St | 3 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 3 | Width 8ft | 6010262.216659999 | 2098999.82172 | 37.7440326285028 | -122.40716947078998 | (37.7440326285028, -122.40716947079) | |||
73395 | 73395 | 205551 | Undocumented 2 | Arbutus unedo :: Strawberry Tree 61 | 125 Hazelwood Ave | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 2 | Width 3ft | 5996483.1105 | 2094435.6321900003 | 37.7307197079512 | -122.45448460318501 | (37.7307197079512, -122.454484603185) | |||
74504 | 74504 | 205584 | Undocumented 2 | Arbutus unedo :: Strawberry Tree 61 | 40 Maywood Dr | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 8 | Width 3ft | 5994325.75965 | 2096193.23667 | 37.735421692758 | -122.462070256959 | (37.735421692758, -122.462070256959) | |||
74800 | 74800 | 205572 | Undocumented 2 | Arbutus unedo :: Strawberry Tree 61 | 114 Santa Paula Ave | 2 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 7 | Width 3ft | 5993972.50918 | 2097090.3840400001 | 37.737864692108396 | -122.46335664900299 | (37.7378646921084, -122.463356649003) | |||
102704 | 102704 | 96293 | Permitted Site 1 | Arbutus unedo :: Strawberry Tree 61 | 417 Dewey Blvd | 2 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 04/25/2011 12:00:00 AM | Permit Number 57003 | 5995136.0 | 2100316.9 | 37.7467908665237 | -122.45956754031602 | (37.7467908665237, -122.459567540316) | |||
133702 | 133702 | 204280 | Undocumented 2 | Arbutus unedo :: Strawberry Tree 61 | 1983 15th Ave | 2 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 10 | Width 3ft | 5991572.44859 | 2101946.22913 | 37.7510590289716 | -122.472008574033 | (37.7510590289716, -122.472008574033) | |||
135028 | 135028 | 205570 | Undocumented 2 | Arbutus unedo :: Strawberry Tree 61 | 95 Santa Paula Ave | 4 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 7 | Width 3ft | 5994005.55165 | 2097177.56666 | 37.7381059775051 | -122.463248730343 | (37.7381059775051, -122.463248730343) | |||
137823 | 137823 | 205540 | Undocumented 2 | Arbutus unedo :: Strawberry Tree 61 | 1526 Plymouth Ave | 2 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 7 | Width 3ft | 5995874.39111 | 2094226.59962 | 37.730110824639794 | -122.456573917178 | (37.7301108246398, -122.456573917178) | |||
137831 | 137831 | 205575 | Undocumented 2 | Arbutus unedo :: Strawberry Tree 61 | 120 Santa Paula Ave | 2 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 3 | Width 3ft | 5993984.55624 | 2097010.92185 | 37.7376472027498 | -122.46330923223101 | (37.7376472027498, -122.463309232231) | |||
147008 | 147008 | 204245 | Undocumented 2 | Arbutus unedo :: Strawberry Tree 61 | 525 Laguna Honda Blvd | 2 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 7 | Width 4ft | 5995534.84133 | 2100102.49255 | 37.746225083015794 | -122.458172879382 | (37.7462250830158, -122.458172879382) | |||
147940 | 147940 | 118015 | Undocumented 2 | Arbutus unedo :: Strawberry Tree 61 | 484 37th Ave | 2 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 7 | Width 6ft | 5984418.072319999 | 2112574.2634400004 | 37.779824014236205 | -122.49753333513901 | (37.7798240142362, -122.497533335139) | |||
150566 | 150566 | 205580 | Undocumented 2 | Arbutus unedo :: Strawberry Tree 61 | 150 Santa Paula Ave | 4 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 2 | Width 3ft | 5993997.03811 | 2096919.5005400002 | 37.7373969016417 | -122.463259444867 | (37.7373969016417, -122.463259444867) | |||
152677 | 152677 | 205585 | Undocumented 2 | Arbutus unedo :: Strawberry Tree 61 | 40 Maywood Dr | 2 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 7 | Width 3ft | 5994312.873380001 | 2096182.99146 | 37.7353928200065 | -122.46211406653299 | (37.7353928200065, -122.462114066533) | |||
152882 | 152882 | 205543 | Undocumented 2 | Arbutus unedo :: Strawberry Tree 61 | 35 Greenwood Ave | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 17 | Width 3ft | 5996424.35956 | 2093713.8664799999 | 37.7287345426545 | -122.45463558948 | (37.7287345426545, -122.45463558948) | |||
155705 | 155705 | 205578 | Undocumented 2 | Arbutus unedo :: Strawberry Tree 61 | 150 Santa Paula Ave | 2 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 2 | Width 3ft | 5993989.91477 | 2096955.84067 | 37.737496272231205 | -122.46328670960699 | (37.7374962722312, -122.463286709607) | |||
161057 | 161057 | 205573 | Undocumented 2 | Arbutus unedo :: Strawberry Tree 61 | 114 Santa Paula Ave | 3 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 7 | Width 3ft | 5993978.105 | 2097062.9530599997 | 37.7377896958481 | -122.46333531168399 | (37.7377896958481, -122.463335311684) | |||
165173 | 165173 | 204287 | Undocumented 2 | Arbutus unedo :: Strawberry Tree 61 | 1723 12th Ave | 5 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 9 | Width 3ft | 5992461.83589 | 2103758.6049200003 | 37.756086768014995 | -122.469064896048 | (37.756086768015, -122.469064896048) | |||
165366 | 165366 | 205592 | Undocumented 2 | Arbutus unedo :: Strawberry Tree 61 | 30 Vasquez Ave | 3 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 9 | Width 3ft | 5995689.638259999 | 2100080.55801 | 37.7461737497157 | -122.457636027276 | (37.7461737497157, -122.457636027276) | |||
167664 | 167664 | 205574 | Undocumented 2 | Arbutus unedo :: Strawberry Tree 61 | 120 Santa Paula Ave | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 3 | Width 3ft | 5993983.2221 | 2097029.04502 | 37.7376968876071 | -122.463315159687 | (37.7376968876071, -122.463315159687) | |||
172101 | 172101 | 246810 | Undocumented 2 | Arbutus unedo :: Strawberry Tree 61 | 161 Brewster St | 2 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 5 | Width 8ft | 6010258.54095 | 2098989.94927 | 37.744005315193895 | -122.407181484852 | (37.7440053151939, -122.407181484852) | |||
176140 | 176140 | 205544 | Undocumented 2 | Arbutus unedo :: Strawberry Tree 61 | 170 Colon Ave | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 14 | Width 3ft | 5996146.907790001 | 2094084.3221599997 | 37.7297358073576 | -122.45562151801701 | (37.7297358073576, -122.455621518017) | |||
178092 | 178092 | 204291 | Undocumented 2 | Arbutus unedo :: Strawberry Tree 61 | 1723 12th Ave | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 8 | Width 3ft | 5992458.815230001 | 2103838.74555 | 37.7563066387524 | -122.46908117467501 | (37.7563066387524, -122.469081174675) | |||
180309 | 180309 | 205538 | Undocumented 2 | Arbutus unedo :: Strawberry Tree 61 | 351 Montecito Ave | 2 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 12 | Width 3ft | 5995944.06447 | 2094085.5653900001 | 37.7297275785675 | -122.45632285521799 | (37.7297275785675, -122.456322855218) | |||
180426 | 180426 | 205557 | Undocumented 2 | Arbutus unedo :: Strawberry Tree 61 | 40 Merced Ave | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 5 | Width 3ft | 5995171.1293 | 2100080.94883 | 37.746145023587204 | -122.459428982288 | (37.7461450235872, -122.459428982288) | |||
184672 | 184672 | 205591 | Undocumented 2 | Arbutus unedo :: Strawberry Tree 61 | 64 Linares Ave | 2 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 8 | Width 3ft | 5994060.21953 | 2102134.15413 | 37.7517186672821 | -122.463419311054 | (37.7517186672821, -122.463419311054) | |||
185515 | 185515 | 204279 | Undocumented 2 | Arbutus unedo :: Strawberry Tree 61 | 1983 15th Ave | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 9 | Width 3ft | 5991574.21623 | 2101962.22104 | 37.7511030408823 | -122.47200362687799 | (37.7511030408823, -122.472003626878) | |||
185843 | 185843 | 205560 | Undocumented 2 | Arbutus unedo :: Strawberry Tree 61 | 417 Dewey Blvd | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 5 | Width 3ft | 5995109.52867 | 2100320.3860400002 | 37.7467989161433 | -122.45965932743799 | (37.7467989161433, -122.459659327438) | |||
187366 | 187366 | 204290 | Undocumented 2 | Arbutus unedo :: Strawberry Tree 61 | 1723 12th Ave | 2 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 7 | Width 3ft | 5992460.07118 | 2103823.87562 | 37.756265882372105 | -122.46907574903999 | (37.7562658823721, -122.46907574904) |
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");