trees

Custom SQL query returning 55 rows (hide)

Query parameters

This data as json, CSV

rowidTreeIDqLegalStatus_idqSpecies_idqAddressSiteOrderqSiteInfoPlantTypeqCaretaker_idqCareAssistantPlantDateDBHPlotSizePermitNotesXCoordYCoordLatitudeLongitudeLocationFire Prevention DistrictsPolice DistrictsSupervisor DistrictsZip CodesNeighborhoods (old)
74236 222859 1 153 100 Church St 4 : Tree 2     9 Width 3ft   6004077.69446 2108250.00646 37.7690833988163 -122.429213605151 (37.7690833988163, -122.429213605151) 7 9 5 28862 3
25126 251400 1 153 101 Rhine St 5 Sidewalk: Curb side : Yard Tree 2       Width 3ft   5994375.43496 2086552.55756 37.7089535675334 -122.461199910156 (37.7089535675334, -122.461199910156) 9 8 6 28861 25
75950 175835 1 153 101 Rhine St 4 Sidewalk: Curb side : Yard Tree 2     5 Width 3ft   5994375.43496 2086552.55756 37.7089535675334 -122.461199910156 (37.7089535675334, -122.461199910156) 9 8 6 28861 25
190723 175837 1 153 101 Rhine St 2 Sidewalk: Curb side : Yard Tree 2     4 Width 3ft   5994356.88277 2086531.76861 37.7088954182656 -122.461262522762 (37.7088954182656, -122.461262522762) 9 8 6 28861 25
191773 175838 1 153 101 Rhine St 1 Sidewalk: Curb side : Yard Tree 2     5 Width 3ft   5994346.0156 2086520.62322 37.7088641902123 -122.461299273568 (37.7088641902123, -122.461299273568) 9 8 6 28861 25
126312 125956 1 153 1047 Mason St 2 Sidewalk: Curb side : Cutout Tree 2     10 Width 3ft   6009450.24252 2117026.36812 37.7934838810207 -122.411250263289 (37.7934838810207, -122.411250263289) 3 1 10 28857 21
137598 125957 1 153 1047 Mason St 3 Sidewalk: Curb side : Cutout Tree 2     9 Width 3ft   6009453.06953 2117007.51923 37.7934322851104 -122.411239149462 (37.7934322851104, -122.411239149462) 3 1 10 28857 21
187258 222864 1 153 1057 Treat Ave 1 Sidewalk: Curb side : Cutout Tree 2     11 Width 3ft   6008644.3268 2102383.5696 37.7532329691398 -122.413002991602 (37.7532329691398, -122.413002991602) 2 4 7 28859 19
97583 205980 1 153 121 Sagamore St 1 Sidewalk: Curb side : Cutout Tree 2     11 Width 3ft   5995564.77238 2087377.85645 37.7112880204943 -122.457149074963 (37.7112880204943, -122.457149074963) 9 8 6 28861 24
84919 188459 1 153 1300 Evans Ave 12 : Tree 2     8 Width 3ft   6017898.8154 2096917.74741 37.7387400867836 -122.380618860675 (37.7387400867836, -122.380618860675) 10 3 8 58 1
88567 188457 1 153 1300 Evans Ave 7 : Tree 2     6 Width 3ft   6017980.56674 2096851.4508 37.7385625606061 -122.380331593842 (37.7385625606061, -122.380331593842) 10 3 8 58 1
88876 188458 1 153 1300 Evans Ave 8 : Tree 2     7 Width 3ft   6017965.45294 2096866.00027 37.7386016766138 -122.38038486158 (37.7386016766138, -122.38038486158) 10 3 8 58 1
92213 222869 1 153 134 Carl St 1 Sidewalk: Curb side : Cutout Tree 2     9 Width 3ft   5997758.85551 2107160.25032 37.7657314672574 -122.450991395353 (37.7657314672574, -122.450991395353) 15 5 11 29492 9
103914 205976 1 153 1701 Irving St 2 Sidewalk: Curb side : Cutout Tree 2     4 Width 3ft   5990268.09461 2106501.35163 37.7634906193203 -122.476851900801 (37.7634906193203, -122.476851900801) 1 8 3 56 12
92393 222882 1 153 1857 Church St 1 Sidewalk: Curb side : Cutout Tree 2     10 Width 3ft   6004605.27602 2097916.14759 37.7407388983737 -122.426652754132 (37.7407388983737, -122.426652754132) 2 7 5 63 7
180116 125952 1 153 2294 Filbert St 1 Sidewalk: Curb side : Cutout Tree 2     11 Width 3ft   6001994.86126 2118787.45338 37.7978984191288 -122.437172562074 (37.7978984191288, -122.437172562074) 13 9 1 57 17
48349 125953 1 153 251 Presidio Ave 1 Sidewalk: Curb side : Cutout Tree 2     7 Width 3ft   5999000.41128 2115755.88881 37.7894038772406 -122.447315856258 (37.7894038772406, -122.447315856258) 13 6 1 54 31
80337 125955 1 153 251 Presidio Ave 3 Sidewalk: Curb side : Cutout Tree 2     6 Width 3ft   5999006.9985 2115714.87548 37.789291641844 -122.447290112255 (37.789291641844, -122.447290112255) 13 6 1 54 31
149476 125954 1 153 251 Presidio Ave 2 Sidewalk: Curb side : Cutout Tree 2     6 Width 3ft   5999004.62741 2115731.3369 37.7893367050801 -122.447299501178 (37.7893367050801, -122.447299501178) 13 6 1 54 31
25953 205978 1 153 26 Taraval St 1 Sidewalk: Curb side : Cutout Tree 2     8 Width 3ft   5993683.84565 2099240.98688 37.7437530733501 -122.464510801149 (37.7437530733501, -122.464510801149) 1 8 4 29491 40
18311 222868 1 153 3665 24th St 2 Sidewalk: Curb side : Cutout Tree 2     5 Width 3ft   6005340.76956 2101936.52609 37.7518194920941 -122.424395579917 (37.7518194920941, -122.424395579917) 2 4 5 28859 19
52841 222867 1 153 3665 24th St 1 Sidewalk: Curb side : Cutout Tree 2     3 Width 3ft   6005333.3615 2101936.42428 37.7518187942162 -122.424421190788 (37.7518187942162, -122.424421190788) 2 4 5 28859 19
116855 222881 1 153 3844 19th St 1 Sidewalk: Curb side : Cutout Tree 2     8 Width 3ft   6004001.37732 2104831.96458 37.7596939568222 -122.429233822808 (37.7596939568222, -122.429233822808) 2 4 5 28862 3
10639 222877 1 153 3850 17th St 1 Sidewalk: Curb side : Cutout Tree 2     6 Width 3ft   6003276.24685 2105959.70039 37.7627493711059 -122.43182221013 (37.7627493711059, -122.43182221013) 15 4 5 28862 3
48900 222878 1 153 3850 17th St 2 Sidewalk: Curb side : Cutout Tree 2     5 Width 3ft   6003263.67356 2105959.60231 37.7627483890498 -122.431865689655 (37.7627483890498, -122.431865689655) 15 4 5 28862 3
92683 222880 1 153 3850 17th St 4 Sidewalk: Curb side : Cutout Tree 2     6 Width 3ft   6003225.60952 2105960.03054 37.7627474070019 -122.431997370179 (37.7627474070019, -122.431997370179) 15 4 5 28862 3
168666 222879 1 153 3850 17th St 3 Sidewalk: Curb side : Cutout Tree 2     5 Width 3ft   6003245.02631 2105961.0603 37.7627513352378 -122.431930287959 (37.7627513352378, -122.431930287959) 15 4 5 28862 3
192537 222873 1 153 4354 21st St 1 Sidewalk: Curb side : Cutout Tree 2     9 Width 3ft   6000914.51326 2103313.56277 37.7553495604475 -122.439800863126 (37.7553495604475, -122.439800863126) 2 4 5 28862 38
127193 205979 1 153 44 Taraval St 1 Sidewalk: Curb side : Cutout Tree 2     11 Width 3ft   5993573.64628 2099229.5165 37.7437152253671 -122.464891008423 (37.7437152253671, -122.464891008423) 1 8 4 29491 40
177372 175828 1 153 490 Harkness Ave 3 Sidewalk: Curb side : Cutout Tree 2     5 Width 3ft   6010182.47488 2089702.17663 37.7184987999604 -122.406790070203 (37.7184987999604, -122.406790070203) 10 7 8 309 39
162799 222875 1 153 70 Natick St 1 Sidewalk: Curb side : Cutout Tree 2     9 Width 3ft   6003058.60804 2095498.12618 37.7340120027534 -122.431827935223 (37.7340120027534, -122.431827935223) 2 7 5 63 7
44326 175834 1 153 71 De Long St 6 : Tree 2     6 Width 3ft   5994720.17465 2086786.57384 37.7096159550821 -122.460025390159 (37.7096159550821, -122.460025390159) 9 8 6 28861 25
71593 175832 1 153 71 De Long St 4 : Tree 2     5 Width 3ft   5994691.10568 2086786.70031 37.7096146303906 -122.460125866041 (37.7096146303906, -122.460125866041) 9 8 6 28861 25
73379 175833 1 153 71 De Long St 5 : Tree 2     5 Width 3ft   5994704.65642 2086785.934 37.709613305686 -122.46007897717 (37.709613305686, -122.46007897717) 9 8 6 28861 25
104937 175831 1 153 71 De Long St 3 : Tree 2     5 Width 3ft   5994675.09306 2086785.58839 37.7096106562906 -122.460181127555 (37.7096106562906, -122.460181127555) 9 8 6 28861 25
107571 175829 1 153 71 De Long St 1 : Tree 2     4 Width 3ft   5994644.58104 2086786.22758 37.709610656267 -122.460286627948 (37.709610656267, -122.460286627948) 9 8 6 28861 25
115792 175830 1 153 71 De Long St 2 : Tree 2     5 Width 3ft   5994659.60487 2086786.3953 37.7096119809882 -122.460234715484 (37.7096119809882, -122.460234715484) 9 8 6 28861 25
128123 175839 1 153 728 Burrows St 6 Sidewalk: Curb side : Cutout Tree 2     9 Width 3ft   6009068.66668 2092869.3876 37.7271329121485 -122.410863628551 (37.7271329121485, -122.410863628551) 9 3 7 309 28
77523 222862 1 153 75 14th St 1 Sidewalk: Curb side : Cutout Tree 2     9 Width 3ft   6008204.35624 2107957.35065 37.7685125829154 -122.414918966632 (37.7685125829154, -122.414918966632) 8 4 7 28853 19
135942 222863 1 153 75 14th St 2 Sidewalk: Curb side : Cutout Tree 2     8 Width 3ft   6008222.11657 2107958.04741 37.7685154940131 -122.414857584305 (37.7685154940131, -122.414857584305) 8 4 7 28853 19
36778 188465 1 153 766 Brannan St 3 Sidewalk: Curb side : Cutout Tree 2     9 Width 3ft   6011787.2831 2109744.85419 37.7736213382813 -122.402651578111 (37.7736213382813, -122.402651578111) 14 2 9 28853 34
23578 188462 1 153 769 Brannan St 3 Sidewalk: Curb side : Cutout Tree 2     6 Width 3ft   6011845.31362 2109707.14292 37.7735210314987 -122.402448188337 (37.7735210314987, -122.402448188337) 14 2 9 28853 34
64231 188461 1 153 769 Brannan St 2 Sidewalk: Curb side : Cutout Tree 2     7 Width 3ft   6011834.92433 2109696.16508 37.7734903088701 -122.40248335455 (37.7734903088701, -122.40248335455) 14 2 9 28853 34
71955 188463 1 153 769 Brannan St 4 Sidewalk: Curb side : Cutout Tree 2     8 Width 3ft   6011854.34986 2109717.34943 37.7735495606877 -122.402417648277 (37.7735495606877, -122.402417648277) 14 2 9 28853 34
147607 188460 1 153 769 Brannan St 1 Sidewalk: Curb side : Cutout Tree 2     7 Width 3ft   6011827.04267 2109686.99498 37.7734646898654 -122.40250997357 (37.7734646898654, -122.40250997357) 14 2 9 28853 34
175081 188464 1 153 769 Brannan St 5 Sidewalk: Curb side : Cutout Tree 2     10 Width 3ft   6011863.90983 2109727.01208 37.7735766257899 -122.402385258275 (37.7735766257899, -122.402385258275) 14 2 9 28853 34
3622 222861 1 153 77 14th St 1 Sidewalk: Curb side : Cutout Tree 2     9 Width 3ft   6008184.4457 2107955.63736 37.7685067598049 -122.414987714411 (37.7685067598049, -122.414987714411) 8 4 7 28853 19
31697 125961 1 153 900 Lombard St 4 Sidewalk: Curb side : Cutout Tree 2     11 Width 3ft   6007947.13488 2120318.93587 37.802440037726 -122.4166845058 (37.802440037726, -122.4166845058) 5 1 1 308 32
124409 125959 1 153 900 Lombard St 2 Sidewalk: Curb side : Cutout Tree 2     10 Width 3ft   6007983.53221 2120324.66338 37.802457811042 -122.416558958654 (37.802457811042, -122.416558958654) 5 1 1 308 32
127308 125960 1 153 900 Lombard St 3 Sidewalk: Curb side : Cutout Tree 2     8 Width 3ft   6007965.18699 2120322.02846 37.8024495444817 -122.416622255608 (37.8024495444817, -122.416622255608) 5 1 1 308 32
140768 125958 1 153 941 Lombard St 2 Sidewalk: Curb side : Cutout Tree 2     11 Width 3ft   6007838.51696 2120251.34871 37.8022483508428 -122.417055586769 (37.8022483508428, -122.417055586769) 5 1 10 308 32
158108 125962 1 153 952 Lombard St 1 Sidewalk: Curb side : Cutout Tree 2     9 Width 3ft   6007785.23718 2120295.43881 37.8023664138362 -122.41724308731 (37.8023664138362, -122.41724308731) 5 1 1 308 32
6934 125964 1 153 954 Lombard St 2 Sidewalk: Curb side : Cutout Tree 2     12 Width 3ft   6007746.87512 2120288.68768 37.8023457186479 -122.4173753605 (37.8023457186479, -122.4173753605) 5 1 1 308 32
117579 125963 1 153 954 Lombard St 1 Sidewalk: Curb side : Cutout Tree 2     8 Width 3ft   6007766.23356 2120291.49428 37.8023545140073 -122.417308569644 (37.8023545140073, -122.417308569644) 5 1 1 308 32
73813 125965 1 153 960 Lombard St 1 Sidewalk: Curb side : Cutout Tree 2     13 Width 3ft   6007714.84364 2120286.14045 37.8023369223605 -122.417486024768 (37.8023369223605, -122.417486024768) 5 1 1 308 32