Data source: data.sfgov.org
This data as json, CSV (advanced)
Suggested facets: qAddress, DBH
Link | rowid ▼ | TreeID | qLegalStatus | qSpecies | qAddress | SiteOrder | qSiteInfo | PlantType | qCaretaker | qCareAssistant | PlantDate | DBH | PlotSize | PermitNotes | XCoord | YCoord | Latitude | Longitude | Location |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
24212 | 24212 | 181351 | Undocumented 2 | Cupressus macrocarpa :: Monterey Cypress 47 | 2300 Sunset Blvd | 5 | unknown : Yard 19 | Tree 1 | Private 1 | 32 | Width 0ft | 5985090.6387 | 2098949.4558 | 37.7424534945744 | -122.49420214621 | (37.7424534945744, -122.49420214621) | |||
24279 | 24279 | 138266 | Undocumented 2 | Cupressus macrocarpa :: Monterey Cypress 47 | 2600 GEARY BLVD | 34 | unknown : Yard 19 | Tree 1 | Private 1 | 19 | Width 0ft | 5999024.6838 | 2113178.2607 | 37.7823277718518 | -122.44704630425699 | (37.7823277718518, -122.447046304257) | |||
25247 | 25247 | 185431 | Undocumented 2 | Cupressus macrocarpa :: Monterey Cypress 47 | 2300 Sunset Blvd | 47 | unknown : Yard 19 | Tree 1 | Private 1 | 40 | Width 0ft | 5985098.6365 | 2099386.335 | 37.743653514796705 | -122.49420668637899 | (37.7436535147967, -122.494206686379) | |||
27191 | 27191 | 186631 | Undocumented 2 | Cupressus macrocarpa :: Monterey Cypress 47 | 1300 Lower Great Hwy | 7 | unknown : Yard 19 | Tree 1 | Private 1 | 2 | Width 0ft | 5980860.0426 | 2105683.7293 | 37.7606954284135 | -122.50933003298901 | (37.7606954284135, -122.509330032989) | |||
29764 | 29764 | 185497 | Undocumented 2 | Cupressus macrocarpa :: Monterey Cypress 47 | 2400 Sunset Blvd | 51 | unknown : Yard 19 | Tree 1 | Private 1 | 33 | Width 0ft | 5985111.7766 | 2098651.8474 | 37.7416375791026 | -122.494107128969 | (37.7416375791026, -122.494107128969) | |||
34013 | 34013 | 185453 | Undocumented 2 | Cupressus macrocarpa :: Monterey Cypress 47 | 2400 Sunset Blvd | 3 | unknown : Yard 19 | Tree 1 | Private 1 | 32 | Width 0ft | 5985125.7214 | 2098256.744 | 37.740553547520705 | -122.494029800854 | (37.7405535475207, -122.494029800854) | |||
34361 | 34361 | 185493 | Undocumented 2 | Cupressus macrocarpa :: Monterey Cypress 47 | 2400 Sunset Blvd | 46 | unknown : Yard 19 | Tree 1 | Private 1 | 19 | Width 0ft | 5985113.7687 | 2098601.3804 | 37.741499126889295 | -122.49409652237499 | (37.7414991268893, -122.494096522375) | |||
34443 | 34443 | 186561 | Undocumented 2 | Cupressus macrocarpa :: Monterey Cypress 47 | 1501 Sunset Blvd | 32 | unknown : Yard 19 | Tree 1 | Private 1 | 85 | Width 0ft | 5984740.943 | 2104715.6846 | 37.758265506246296 | -122.495836533834 | (37.7582655062463, -122.495836533834) | |||
34689 | 34689 | 186540 | Undocumented 2 | Cupressus macrocarpa :: Monterey Cypress 47 | 1501 Sunset Blvd | 11 | unknown : Yard 19 | Tree 1 | Private 1 | 2 | Width 0ft | 5984760.5184 | 2104876.1604 | 37.7587072745291 | -122.49578067192199 | (37.7587072745291, -122.495780671922) | |||
37856 | 37856 | 185490 | Undocumented 2 | Cupressus macrocarpa :: Monterey Cypress 47 | 2400 Sunset Blvd | 43 | unknown : Yard 19 | Tree 1 | Private 1 | 18 | Width 0ft | 5985127.7135 | 2098570.8346 | 37.741416072315204 | -122.49404605602501 | (37.7414160723152, -122.494046056025) | |||
38172 | 38172 | 185416 | Undocumented 2 | Cupressus macrocarpa :: Monterey Cypress 47 | 2300 Sunset Blvd | 32 | unknown : Yard 19 | Tree 1 | Private 1 | 5 | Width 0ft | 5985081.6412 | 2099232.3776 | 37.743229794878296 | -122.49425410551599 | (37.7432297948783, -122.494254105516) | |||
38441 | 38441 | 185474 | Undocumented 2 | Cupressus macrocarpa :: Monterey Cypress 47 | 2400 Sunset Blvd | 26 | unknown : Yard 19 | Tree 1 | Private 1 | 27 | Width 0ft | 5985113.1047 | 2098438.0268 | 37.7410505630538 | -122.494086781525 | (37.7410505630538, -122.494086781525) | |||
39570 | 39570 | 186559 | Undocumented 2 | Cupressus macrocarpa :: Monterey Cypress 47 | 1501 Sunset Blvd | 30 | unknown : Yard 19 | Tree 1 | Private 1 | 2 | Width 0ft | 5984761.8792 | 2104726.5714 | 37.7582966244824 | -122.495764931436 | (37.7582966244824, -122.495764931436) | |||
40115 | 40115 | 185505 | Undocumented 2 | Cupressus macrocarpa :: Monterey Cypress 47 | 2400 Sunset Blvd | 59 | unknown : Yard 19 | Tree 1 | Private 1 | 19 | Width 0ft | 5985087.8712 | 2098781.9991 | 37.7419935417222 | -122.49419937536501 | (37.7419935417222, -122.494199375365) | |||
45810 | 45810 | 185494 | Undocumented 2 | Cupressus macrocarpa :: Monterey Cypress 47 | 2400 Sunset Blvd | 47 | unknown : Yard 19 | Tree 1 | Private 1 | 25 | Width 0ft | 5985136.346 | 2098616.6534 | 37.74154238350489 | -122.494019584309 | (37.7415423835049, -122.494019584309) | |||
53374 | 53374 | 185417 | Undocumented 2 | Cupressus macrocarpa :: Monterey Cypress 47 | 2300 Sunset Blvd | 33 | unknown : Yard 19 | Tree 1 | Private 1 | 24 | Width 0ft | 5985081.6412 | 2099246.8736 | 37.7432695969748 | -122.49425517376801 | (37.7432695969748, -122.494255173768) | |||
57083 | 57083 | 185434 | Undocumented 2 | Cupressus macrocarpa :: Monterey Cypress 47 | 2300 Sunset Blvd | 50 | unknown : Yard 19 | Tree 1 | Private 1 | 20 | Width 0ft | 5985080.6415 | 2099410.3284 | 37.7437183411386 | -122.494270675975 | (37.7437183411386, -122.494270675975) | |||
62482 | 62482 | 185414 | Undocumented 2 | Cupressus macrocarpa :: Monterey Cypress 47 | 2300 Sunset Blvd | 30 | unknown : Yard 19 | Tree 1 | Private 1 | 3 | Width 0ft | 5985079.1419 | 2099209.8838 | 37.743167886728 | -122.494261089675 | (37.743167886728, -122.494261089675) | |||
64027 | 64027 | 186552 | Undocumented 2 | Cupressus macrocarpa :: Monterey Cypress 47 | 1501 Sunset Blvd | 23 | unknown : Yard 19 | Tree 1 | Private 1 | 2 | Width 0ft | 5984760.623 | 2104776.3995 | 37.758433365006105 | -122.49577295137699 | (37.7584333650061, -122.495772951377) | |||
66692 | 66692 | 185457 | Undocumented 2 | Cupressus macrocarpa :: Monterey Cypress 47 | 2400 Sunset Blvd | 7 | unknown : Yard 19 | Tree 1 | Private 1 | 13 | Width 0ft | 5985129.0416 | 2098307.8751 | 37.740694134038 | -122.494022088477 | (37.740694134038, -122.494022088477) | |||
68374 | 68374 | 185458 | Undocumented 2 | Cupressus macrocarpa :: Monterey Cypress 47 | 2400 Sunset Blvd | 8 | unknown : Yard 19 | Tree 1 | Private 1 | 22 | Width 0ft | 5985125.7214 | 2098330.4524 | 37.7407559309555 | -122.49403523184401 | (37.7407559309555, -122.494035231844) | |||
73057 | 73057 | 185408 | Undocumented 2 | Cupressus macrocarpa :: Monterey Cypress 47 | 2300 Sunset Blvd | 23 | unknown : Yard 19 | Tree 1 | Private 1 | 10 | Width 0ft | 5985102.6354 | 2099127.4066 | 37.742942801420796 | -122.49417377884599 | (37.7429428014208, -122.494173778846) | |||
73687 | 73687 | 186630 | Undocumented 2 | Cupressus macrocarpa :: Monterey Cypress 47 | 1300 Lower Great Hwy | 6 | unknown : Yard 19 | Tree 1 | Private 1 | 2 | Width 0ft | 5980860.7453 | 2105672.8381 | 37.7606655657469 | -122.50932679385099 | (37.7606655657469, -122.509326793851) | |||
76180 | 76180 | 185454 | Undocumented 2 | Cupressus macrocarpa :: Monterey Cypress 47 | 2400 Sunset Blvd | 4 | unknown : Yard 19 | Tree 1 | Private 1 | 25 | Width 0ft | 5985131.0337 | 2098272.681 | 37.7405976170701 | -122.494012607503 | (37.7405976170701, -122.494012607503) | |||
132337 | 132337 | 186535 | Undocumented 2 | Cupressus macrocarpa :: Monterey Cypress 47 | 1501 Sunset Blvd | 6 | unknown : Yard 19 | Tree 1 | Private 1 | 2 | Width 0ft | 5984732.8826 | 2104894.5843 | 37.7587562429314 | -122.495877606831 | (37.7587562429314, -122.495877606831) | |||
134120 | 134120 | 185507 | Undocumented 2 | Cupressus macrocarpa :: Monterey Cypress 47 | 2400 Sunset Blvd | 61 | unknown : Yard 19 | Tree 1 | Private 1 | 40 | Width 0ft | 5985116.4249 | 2098801.2563 | 37.7420480876484 | -122.494102066238 | (37.7420480876484, -122.494102066238) | |||
134264 | 134264 | 185433 | Undocumented 2 | Cupressus macrocarpa :: Monterey Cypress 47 | 2300 Sunset Blvd | 49 | unknown : Yard 19 | Tree 1 | Private 1 | 2 | Width 0ft | 5985073.6434 | 2099396.3323 | 37.7436795021074 | -122.49429384193199 | (37.7436795021074, -122.494293841932) | |||
136486 | 136486 | 186550 | Undocumented 2 | Cupressus macrocarpa :: Monterey Cypress 47 | 1501 Sunset Blvd | 21 | unknown : Yard 19 | Tree 1 | Private 1 | 42 | Width 0ft | 5984736.7558 | 2104791.4736 | 37.7584733565115 | -122.49585660551 | (37.7584733565115, -122.49585660551) | |||
137771 | 137771 | 181360 | Undocumented 2 | Cupressus macrocarpa :: Monterey Cypress 47 | 2400 Sunset Blvd | 49 | unknown : Yard 19 | Tree 1 | Private 1 | 47 | Width 0ft | 5985113.1047 | 2098629.2701 | 37.7415756656355 | -122.494100873291 | (37.7415756656355, -122.494100873291) | |||
150480 | 150480 | 186577 | Undocumented 2 | Cupressus macrocarpa :: Monterey Cypress 47 | 1501 Sunset Blvd | 48 | unknown : Yard 19 | Tree 1 | Private 1 | 29 | Width 0ft | 5984764.3916 | 2104600.9543 | 37.75795186201471 | -122.495746976697 | (37.7579518620147, -122.495746976697) | |||
153024 | 153024 | 186626 | Undocumented 2 | Cupressus macrocarpa :: Monterey Cypress 47 | 1300 Lower Great Hwy | 2 | unknown : Yard 19 | Tree 1 | Private 1 | 7 | Width 0ft | 5980879.19 | 2105650.5288 | 37.7606053983358 | -122.509261346313 | (37.7606053983358, -122.509261346313) | |||
155462 | 155462 | 186632 | Undocumented 2 | Cupressus macrocarpa :: Monterey Cypress 47 | 1300 Lower Great Hwy | 8 | unknown : Yard 19 | Tree 1 | Private 1 | 5 | Width 0ft | 5980861.0966 | 2105687.2426 | 37.7607051370684 | -122.509326648666 | (37.7607051370684, -122.509326648666) | |||
157058 | 157058 | 185451 | Undocumented 2 | Cupressus macrocarpa :: Monterey Cypress 47 | 2400 Sunset Blvd | 1 | unknown : Yard 19 | Tree 1 | Private 1 | 30 | Width 0ft | 5985130.3697 | 2098228.1903 | 37.740475418723506 | -122.49401162519399 | (37.7404754187235, -122.494011625194) | |||
166154 | 166154 | 186488 | Undocumented 2 | Cupressus macrocarpa :: Monterey Cypress 47 | 1400 Lower Great Hwy | 34 | unknown : Yard 19 | Tree 1 | Private 1 | 15 | Width 0ft | 5980888.4423 | 2105382.2174 | 37.7598692379346 | -122.50920942183998 | (37.7598692379346, -122.50920942184) | |||
172365 | 172365 | 186543 | Undocumented 2 | Cupressus macrocarpa :: Monterey Cypress 47 | 1501 Sunset Blvd | 14 | unknown : Yard 19 | Tree 1 | Private 1 | 21 | Width 0ft | 5984724.0894 | 2104873.2294 | 37.7586970933352 | -122.495906441969 | (37.7586970933352, -122.495906441969) | |||
172640 | 172640 | 185503 | Undocumented 2 | Cupressus macrocarpa :: Monterey Cypress 47 | 2400 Sunset Blvd | 57 | unknown : Yard 19 | Tree 1 | Private 1 | 40 | Width 0ft | 5985131.0337 | 2098785.3193 | 37.7420051837622 | -122.49405038008001 | (37.7420051837622, -122.49405038008) | |||
172749 | 172749 | 186574 | Undocumented 2 | Cupressus macrocarpa :: Monterey Cypress 47 | 1501 Sunset Blvd | 45 | unknown : Yard 19 | Tree 1 | Private 1 | 46 | Width 0ft | 5984720.0068 | 2104642.8266 | 37.7580642323025 | -122.495903564638 | (37.7580642323025, -122.495903564638) | |||
174389 | 174389 | 186633 | Undocumented 2 | Cupressus macrocarpa :: Monterey Cypress 47 | 1300 Lower Great Hwy | 9 | unknown : Yard 19 | Tree 1 | Private 1 | 3 | Width 0ft | 5980876.555 | 2105686.5399 | 37.760704119089 | -122.509273133786 | (37.760704119089, -122.509273133786) | |||
175132 | 175132 | 185488 | Undocumented 2 | Cupressus macrocarpa :: Monterey Cypress 47 | 2400 Sunset Blvd | 41 | unknown : Yard 19 | Tree 1 | Private 1 | 27 | Width 0ft | 5985122.4012 | 2098536.3046 | 37.741320951397704 | -122.494061879541 | (37.7413209513977, -122.494061879541) | |||
178107 | 178107 | 186569 | Undocumented 2 | Cupressus macrocarpa :: Monterey Cypress 47 | 1501 Sunset Blvd | 40 | unknown : Yard 19 | Tree 1 | Private 1 | 26 | Width 0ft | 5984763.5541 | 2104672.9747 | 37.7581495609485 | -122.49575518551701 | (37.7581495609485, -122.495755185517) | |||
178149 | 178149 | 181354 | Undocumented 2 | Cupressus macrocarpa :: Monterey Cypress 47 | 2300 Sunset Blvd | 19 | unknown : Yard 19 | Tree 1 | Private 1 | 25 | Width 0ft | 5985076.1427 | 2099074.9211 | 37.742797140118796 | -122.494261514147 | (37.7427971401188, -122.494261514147) | |||
178921 | 178921 | 186554 | Undocumented 2 | Cupressus macrocarpa :: Monterey Cypress 47 | 1501 Sunset Blvd | 25 | unknown : Yard 19 | Tree 1 | Private 1 | 4 | Width 0ft | 5984714.9821 | 2104746.2514 | 37.7583479137241 | -122.495928571528 | (37.7583479137241, -122.495928571528) | |||
179607 | 179607 | 185430 | Undocumented 2 | Cupressus macrocarpa :: Monterey Cypress 47 | 2300 Sunset Blvd | 46 | unknown : Yard 19 | Tree 1 | Private 1 | 3 | Width 0ft | 5985106.6343 | 2099374.8382 | 37.7436224157034 | -122.49417818512899 | (37.7436224157034, -122.494178185129) | |||
181515 | 181515 | 185432 | Undocumented 2 | Cupressus macrocarpa :: Monterey Cypress 47 | 2300 Sunset Blvd | 48 | unknown : Yard 19 | Tree 1 | Private 1 | 28 | Width 0ft | 5985081.6412 | 2099386.335 | 37.7436525202566 | -122.49426545113899 | (37.7436525202566, -122.494265451139) | |||
183931 | 183931 | 185393 | Undocumented 2 | Cupressus macrocarpa :: Monterey Cypress 47 | 2300 Sunset Blvd | 6 | unknown : Yard 19 | Tree 1 | Private 1 | 30 | Width 0ft | 5985089.6389999995 | 2098965.9512 | 37.742498727988895 | -122.49420681837499 | (37.7424987279889, -122.494206818375) | |||
185674 | 185674 | 185392 | Undocumented 2 | Cupressus macrocarpa :: Monterey Cypress 47 | 2300 Sunset Blvd | 3 | unknown : Yard 19 | Tree 1 | Private 1 | 38 | Width 0ft | 5985108.1339 | 2098944.4572 | 37.7424407935289 | -122.494141285581 | (37.7424407935289, -122.494141285581) | |||
188560 | 188560 | 185508 | Undocumented 2 | Cupressus macrocarpa :: Monterey Cypress 47 | 2400 Sunset Blvd | 62 | unknown : Yard 19 | Tree 1 | Private 1 | 5 | Width 0ft | 5985138.3382 | 2098803.9124 | 37.742056662806796 | -122.494026493821 | (37.7420566628068, -122.494026493821) |
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");