sf-trees

Data source: data.sfgov.org

Custom SQL query returning 101 rows (hide)

Query parameters

rowidTreeIDqLegalStatusqSpeciesqAddressSiteOrderqSiteInfoPlantTypeqCaretakerqCareAssistantPlantDateDBHPlotSizePermitNotesXCoordYCoordLatitudeLongitudeLocation
67550 189912 2 97 1 Flora St 8 4 1 1     4 Width 3ft   6013884.75868 2094408.4745200002 37.7316278064595 -122.394322041155 (37.7316278064595, -122.394322041155)
72242 189913 2 97 1 Flora St 9 4 1 1     6 Width 3ft   6013888.27035 2094422.90108 37.731667614051 -122.39431091023 (37.731667614051, -122.39431091023)
74016 189915 2 97 1 Flora St 13 4 1 1     5 Width 3ft   6013899.07383 2094479.41823 37.7318233991302 -122.394277515688 (37.7318233991302, -122.394277515688)
166137 189911 2 97 1 Flora St 7 4 1 1     5 Width 3ft   6013879.72064 2094387.8060700002 37.73157077506371 -122.394338012196 (37.7315707750637, -122.394338012196)
173975 189914 2 97 1 Flora St 11 4 1 1     5 Width 3ft   6013894.185819999 2094452.33408 37.7317487598799 -122.394292519091 (37.7317487598799, -122.394292519091)
164903 201371 2 97 1 Hare St 1 2 1 1     12     6018297.03999 2095334.9344400002 37.7344159629251 -122.379132069983 (37.7344159629251, -122.379132069983)
23951 222885 2 97 1 Valencia St 3 4 1 1     18 Width 5ft   6006051.02822 2109339.24494 37.7721857010308 -122.422465357814 (37.7721857010308, -122.422465357814)
30049 222884 2 97 1 Valencia St 1 4 1 1     18 Width 5ft   6006058.1722800005 2109199.11331 37.7718013362 -122.422430687153 (37.7718013362, -122.422430687153)
121279 112815 2 97 10 LOMITA AVE 1 1 1 1       3x3   5991472.0 2104830.0 37.7589712942358 -122.472566156736 (37.7589712942358, -122.472566156736)
126890 206004 2 97 10 Lomita Ave 1 1 1 1     7 Width 3ft   5991469.80126 2104851.05791 37.7590289864229 -122.472575296214 (37.7590289864229, -122.472575296214)
34241 125971 2 97 100 Hyde St 1 1 1 1     19 Width 4ft   6008148.4886 2112831.1491900003 37.7818917385495 -122.415457300812 (37.7818917385495, -122.415457300812)
33099 189852 2 97 100 Newhall St 2 4 1 1     8 Width 3ft   6017365.88907 2098130.81013 37.7420414890213 -122.38254586948999 (37.7420414890213, -122.38254586949)
25692 222915 2 97 100 Webster St 1 1 1 1     18 Width 4ft   6004287.81752 2109130.32918 37.7715124442731 -122.42854956011999 (37.7715124442731, -122.42854956012)
119633 103345 2 97 1000 Brannan St 3 1 1 1     16 3x3 Permit Number 29899 6010491.0 2108479.0 37.7700731362443 -122.407046397751 (37.7700731362443, -122.407046397751)
181328 189963 2 97 1000 Brannan St 5 1 1 1     14 Width 3ft   6010349.36768 2108372.96344 37.7697740574441 -122.40752882731 (37.7697740574441, -122.40752882731)
63520 200192 2 97 1008 Jamestown Ave 3 1 1 1     8 Width 0ft   6013935.7075 2089708.6863 37.718725965018 -122.393817050636 (37.718725965018, -122.393817050636)
13616 83038 2 97 100X Cargo Way 14 1 1 1 1 02/04/2006 12:00:00 AM       6018593.33009 2097780.6594 37.7411477742489 -122.378277419086 (37.7411477742489, -122.378277419086)
32657 189845 2 97 101 Newhall St 7 4 1 1     6 Width 3ft   6017192.34248 2098175.05438 37.7421533862633 -122.383149023221 (37.7421533862633, -122.383149023221)
33190 189849 2 97 101 Newhall St 12 4 1 1     10 Width 4ft   6017283.17469 2098125.85242 37.742023306530704 -122.38283152746 (37.7420233065307, -122.38283152746)
38544 189841 2 97 101 Newhall St 3 4 1 1     1 Width 3ft   6017113.188630001 2098207.21128 37.742237308295294 -122.38342495321899 (37.7422373082953, -122.383424953219)
60830 189847 2 97 101 Newhall St 9 4 1 1     1 Width 3ft   6017231.39271 2098158.2223400003 37.7421093266962 -122.383012827183 (37.7421093266962, -122.383012827183)
131320 189846 2 97 101 Newhall St 8 4 1 1     1 Width 3ft   6017214.17115 2098166.7194 37.7421317063069 -122.383072965771 (37.7421317063069, -122.383072965771)
131495 189850 2 97 101 Newhall St 14 4 1 1     9 Width 3ft   6017345.725190001 2098082.05897 37.7419065142755 -122.382612199015 (37.7419065142755, -122.382612199015)
132013 189839 2 97 101 Newhall St 1 4 1 1     1 Width 3ft   6017074.26086 2098217.41845 37.7422631836031 -122.38356026519699 (37.7422631836031, -122.383560265197)
137584 189851 2 97 101 Newhall St 15 4 1 1     12 Width 3ft   6017359.84801 2098072.09609 37.741879938402704 -122.38256267332198 (37.7418799384027, -122.382562673322)
147716 189842 2 97 101 Newhall St 4 4 1 1     7 Width 3ft   6017136.0861599995 2098201.14709 37.7422219227174 -122.383345357813 (37.7422219227174, -122.383345357813)
157361 189848 2 97 101 Newhall St 11 4 1 1     8 Width 4ft   6017264.73109 2098137.17538 37.7420533780644 -122.38289608801 (37.7420533780644, -122.38289608801)
157640 189843 2 97 101 Newhall St 5 4 1 1     1 Width 3ft   6017155.58292 2098191.33075 37.742196046505 -122.38327726024599 (37.742196046505, -122.383277260246)
160768 189840 2 97 101 Newhall St 2 4 1 1     3 Width 3ft   6017094.37686 2098212.93845 37.7422519942486 -122.383490397763 (37.7422519942486, -122.383490397763)
184302 189844 2 97 101 Newhall St 6 1 1 1     4 Width 3ft   6017173.06513 2098183.08322 37.742174366561606 -122.383216237654 (37.7421743665616, -122.383216237654)
24219 189857 2 97 102 Newhall St 7 4 1 1     11 Width 4ft   6017207.28329 2098227.98563 37.7422995503725 -122.383101045278 (37.7422995503725, -122.383101045278)
49848 189861 2 97 102 Newhall St 11 4 1 1     8 Width 3ft   6017125.66493 2098258.40905 37.742378576526 -122.38338537673799 (37.742378576526, -122.383385376738)
63863 189858 2 97 102 Newhall St 8 4 1 1     10 Width 4ft   6017192.206809999 2098235.0383900004 37.7423180827181 -122.38315366643499 (37.7423180827181, -122.383153666435)
67535 189863 2 97 102 Newhall St 13 4 1 1     9 Width 3ft   6017087.002669999 2098268.01639 37.742402819541795 -122.383519729148 (37.7424028195418, -122.383519729148)
135439 189860 2 97 102 Newhall St 10 4 1 1     7 Width 3ft   6017146.31011 2098252.64566 37.74236389238379 -122.38331359014299 (37.7423638923838, -122.383313590143)
156617 189856 2 97 102 Newhall St 6 4 1 1     6 Width 3ft   6017223.11391 2098220.2806700002 37.742279268865104 -122.383045771154 (37.7422792688651, -122.383045771154)
156633 189862 2 97 102 Newhall St 12 4 1 1     7 Width 3ft   6017103.28687 2098264.2675900003 37.7423934261135 -122.383463161819 (37.7423934261135, -122.383463161819)
158918 189855 2 97 102 Newhall St 5 4 1 1     9 Width 3ft   6017245.40272 2098209.38961 37.7422505957884 -122.382967944715 (37.7422505957884, -122.382967944715)
162643 189859 2 97 102 Newhall St 9 4 1 1     7 Width 3ft   6017171.36242 2098242.65136 37.7423378345214 -122.38322627048001 (37.7423378345214, -122.38322627048)
173588 189854 2 97 102 Newhall St 4 4 1 1     10 Width 3ft   6017283.71117 2098187.47887 37.742192549946104 -122.38283396012599 (37.7421925499461, -122.382833960126)
179431 189853 2 97 102 Newhall St 1 4 1 1     8 Width 3ft   6017352.03209 2098141.27696 37.742069463331106 -122.382594511142 (37.7420694633311, -122.382594511142)
23379 222925 2 97 1025 Clayton St 2 1 1 1     12 Width 4ft   5998825.08997 2106348.09575 37.763562478748604 -122.44724507779499 (37.7635624787486, -122.447245077795)
174584 222924 2 97 1025 Clayton St 1 1 1 1     12 Width 4ft   5998822.080680001 2106365.6721900003 37.763610567293 -122.447256751019 (37.763610567293, -122.447256751019)
137538 222914 2 97 108 Webster St 1 1 1 1     14 Width 2ft   6004276.58953 2109191.75922 37.7716804808011 -122.428592777936 (37.7716804808011, -122.428592777936)
32636 222888 2 97 109 Webster St 1 1 1 1     14 Width 4ft   6004218.0 2109157.0 37.771581724556604 -122.428792964354 (37.7715817245566, -122.428792964354)
20496 97187 2 97 10X Fremont St 9 1 1 1     5 3x3   6013222.5 2116242.1 37.7915413037038 -122.398142826086 (37.7915413037038, -122.398142826086)
79194 97180 2 97 10X Fremont St 2 1 1 1     5 3x3   6013222.5 2116242.1 37.7915413037038 -122.398142826086 (37.7915413037038, -122.398142826086)
103650 97186 2 97 10X Fremont St 8 1 1 1     5 3x3   6013222.5 2116242.1 37.7915413037038 -122.398142826086 (37.7915413037038, -122.398142826086)
103733 97188 2 97 10X Fremont St 10 1 1 1     5 3x3   6013222.5 2116242.1 37.7915413037038 -122.398142826086 (37.7915413037038, -122.398142826086)
107120 97182 2 97 10X Fremont St 4 1 1 1     5 3x3   6013222.5 2116242.1 37.7915413037038 -122.398142826086 (37.7915413037038, -122.398142826086)
109098 97181 2 97 10X Fremont St 3 1 1 1     5 3x3   6013222.5 2116242.1 37.7915413037038 -122.398142826086 (37.7915413037038, -122.398142826086)
109377 97184 2 97 10X Fremont St 6 1 1 1     5 3x3   6013138.0 2116168.0 37.791333135618 -122.398429995238 (37.791333135618, -122.398429995238)
122587 97183 2 97 10X Fremont St 5 1 1 1     5 3x3   6013222.5 2116242.1 37.7915413037038 -122.398142826086 (37.7915413037038, -122.398142826086)
123040 97185 2 97 10X Fremont St 7 1 1 1     5 3x3   6013222.5 2116242.1 37.7915413037038 -122.398142826086 (37.7915413037038, -122.398142826086)
124887 97179 2 97 10X Fremont St 1 1 1 1     5 3x3   6013408.0 2116114.0 37.7911999015077 -122.397492006217 (37.7911999015077, -122.397492006217)
33356 248279 2 97 111 Lundy's Ln 1 1 1 1     13 Width 3ft   6006822.34586 2098891.67697 37.743542578041 -122.419056125953 (37.743542578041, -122.419056125953)
113525 113693 2 97 112 LUNDYS LN 2 1 1 1       3x5   6006814.0 2098928.0 37.7436418429474 -122.419087559811 (37.7436418429474, -122.419087559811)
144112 113692 2 97 112 LUNDYS LN 1 1 1 1     14 3x3   6006814.0 2098928.0 37.7436418429474 -122.419087559811 (37.7436418429474, -122.419087559811)
45296 248254 2 97 112 Lundy's Ln 2 1 1 1     13 Width 3ft   6006798.65634 2098892.16282 37.7435425780247 -122.419138073069 (37.7435425780247, -122.419138073069)
176531 248253 2 97 112 Lundy's Ln 1 1 1 1     14 Width 3ft   6006804.331590001 2098902.21261 37.7435704920937 -122.419119162122 (37.7435704920937, -122.419119162122)
64492 222913 2 97 112 Webster St 1 1 1 1     13 Width 3ft   6004271.62218 2109232.3150299997 37.771791556066 -122.428612851729 (37.771791556066, -122.428612851729)
32711 124322 2 97 115 Jordan Ave 1 2 1 1     8 Width 3ft   5996192.87314 2113669.7360400003 37.7835150337529 -122.456878613619 (37.7835150337529, -122.456878613619)
51566 124321 2 97 115 Jordan Ave 2 2 1 1     14 Width 3ft   5996193.40211 2113658.2283900003 37.783483467186706 -122.45687595100901 (37.7834834671867, -122.456875951009)
26990 222896 2 97 115 Julian Ave 1 1 1 1     18 Width 4ft   6006441.81181 2107164.43854 37.76623623692421 -122.420959163358 (37.7662362369242, -122.420959163358)
156357 248255 2 97 116 Lundy's Ln 1 1 1 1     10 Width 3ft   6006791.47872 2098879.96545 37.7435086825726 -122.41916202653 (37.7435086825726, -122.41916202653)
55327 189949 2 97 120 Howard St 2 1 1 1     12 Width 3ft   6014767.16396 2116087.91405 37.791203859513004 -122.392787475772 (37.791203859513, -122.392787475772)
75800 189950 2 97 120 Howard St 4 1 1 1     9 Width 2ft   6014741.1957 2116062.8749700002 37.79113366564629 -122.392875573361 (37.7911336656463, -122.392875573361)
96732 189953 2 97 120 Howard St 7 1 1 1     9 Width 3ft   6014700.62775 2116023.46282 37.7910231956157 -122.39301317951201 (37.7910231956157, -122.393013179512)
161429 189951 2 97 120 Howard St 5 1 1 1     8 Width 1ft   6014728.34644 2116051.81938 37.791102595846894 -122.39291925791099 (37.7911025958469, -122.392919257911)
179956 189952 2 97 120 Howard St 6 1 1 1     9 Width 1ft   6014715.63981 2116037.4080000003 37.7910623197318 -122.392962214036 (37.7910623197318, -122.392962214036)
66722 248258 2 97 120 Lundy's Ln 2 1 1 1     15 Width 3ft   6006769.1868199995 2098841.93634 37.7434030077589 -122.41923640944201 (37.7434030077589, -122.419236409442)
179238 248257 2 97 120 Lundy's Ln 1 1 1 1     13 Width 3ft   6006778.60351 2098856.6294 37.7434438819296 -122.41920489088899 (37.7434438819296, -122.419204890889)
132092 206014 2 97 120 San Benito Way 1 1 1 1     7 Width 3ft   5992843.12782 2095854.05613 37.7344049138512 -122.467171573123 (37.7344049138512, -122.467171573123)
53992 222919 2 97 121 Carl St 1 1 1 1     9 Width 3ft   5997880.24105 2107132.61559 37.765662537824895 -122.45056955843701 (37.7656625378249, -122.450569558437)
174407 222887 2 97 123 Webster St 1 4 1 1     13 Width 5ft   6004226.51196 2109212.81898 37.77173547164 -122.42876750091801 (37.77173547164, -122.428767500918)
129912 225061 2 97 1289 Stanyan St 1 1 1 1     8 Width 6ft   5997502.5049 2105021.0962900002 37.7598432128005 -122.451723726786 (37.7598432128005, -122.451723726786)
54347 206013 2 97 130 San Benito Way 1 1 1 1     12 Width 3ft   5992845.13508 2095810.8192900002 37.7342863121439 -122.467161490835 (37.7342863121439, -122.467161490835)
165360 248260 2 97 132 Lundy's Ln 1 1 1 1     14 Width 3ft   6006738.11061 2098784.48151 37.7432434994904 -122.419339788302 (37.7432434994904, -122.419339788302)
39562 199697 2 97 1331 Thomas Ave 2 1 1 1     8 Width 0ft   6016182.8401 2092843.0517 37.7274569422187 -122.386267947878 (37.7274569422187, -122.386267947878)
174686 199696 2 97 1337 Thomas Ave 1 1 1 1     7 Width 0ft   6016147.0349 2092868.9416 37.7275260488519 -122.386393532075 (37.7275260488519, -122.386393532075)
68963 199693 2 97 1341 Thomas Ave 1 1 1 1     6 Width 0ft   6016099.1110000005 2092907.501 37.7276292724139 -122.386561894416 (37.7276292724139, -122.386561894416)
37989 199692 2 97 1343 Thomas Ave 2 1 1 1     5 Width 0ft   6016085.8906 2092920.1706 37.7276633287451 -122.386608480998 (37.7276633287451, -122.386608480998)
62337 199691 2 97 1343 Thomas Ave 1 1 1 1     4 Width 0ft   6016071.0177 2092930.0859 37.7276897308085 -122.38666058841001 (37.7276897308085, -122.38666058841)
45389 248262 2 97 136 Lundy's Ln 2 1 1 1     19 Width 3ft   6006723.28629 2098755.01317 37.743161751109 -122.41938895693 (37.743161751109, -122.41938895693)
104259 248261 2 97 136 Lundy's Ln 1 1 1 1     10 Width 3ft   6006731.57977 2098768.277 37.7431986377163 -122.419361220966 (37.7431986377163, -122.419361220966)
46452 248275 2 97 137 Lundy's Ln 2 1 1 1     9 Width 3ft   6006752.53211 2098758.7700799997 37.743173713897 -122.41928809889299 (37.743173713897, -122.419288098893)
135232 248274 2 97 137 Lundy's Ln 1 1 1 1     9 Width 3ft   6006747.61558 2098750.1570099997 37.743149787441 -122.419304488116 (37.743149787441, -122.419304488116)
183547 248276 2 97 137 Lundy's Ln 3 1 1 1     10 Width 3ft   6006755.61156 2098766.6947 37.7431956465585 -122.41927801298401 (37.7431956465585, -122.419278012984)
163059 225062 2 97 139 Downey St 1 1 1 1     10 Width 3ft   5998883.5307 2107364.0663900003 37.76635541778779 -122.44711607094601 (37.7663554177878, -122.447116070946)
182071 222886 2 97 139 Webster St 1 4 1 1     15 Width 3ft   6004216.91806 2109283.17336 37.7719281046318 -122.428805703247 (37.7719281046318, -122.428805703247)
135516 247504 2 97 1398 Haight St 1 1 1 1     15 Width 0ft   5999483.6766 2108789.6708 37.7703040400286 -122.44514278745399 (37.7703040400286, -122.445142787454)
31832 222918 2 97 140 Carl St 1 1 1 1     15 Width 3ft   5997702.832359999 2107152.93734 37.7657081802151 -122.451184638974 (37.7657081802151, -122.451184638974)
61155 111886 2 97 140 LUNDYS LN 1 1 1 1     12 3x12   6006709.0 2098750.0 37.7431471814186 -122.41943799965 (37.7431471814186, -122.41943799965)
104253 111888 2 97 140 LUNDYS LN 3 1 1 1       3x12   6006709.0 2098750.0 37.7431471814186 -122.41943799965 (37.7431471814186, -122.41943799965)
126258 111887 2 97 140 LUNDYS LN 2 1 1 1     12 3x12   6006709.0 2098750.0 37.7431471814186 -122.41943799965 (37.7431471814186, -122.41943799965)
50402 248264 2 97 140 Lundy's Ln 2 1 1 1     12 Width 3ft   6006711.60121 2098736.3727599997 37.743109910586 -122.419428038785 (37.743109910586, -122.419428038785)
68659 248263 2 97 140 Lundy's Ln 1 1 1 1     10 Width 3ft   6006717.3063 2098747.87418 37.743141812234505 -122.41940912783899 (37.7431418122345, -122.419409127839)
59090 189955 2 97 145 Main St 2 1 1 1     15 Width 4ft   6014561.092019999 2115949.59191 37.790812611275 -122.39349079958299 (37.790812611275, -122.393490799583)
169467 189954 2 97 145 Main St 1 1 1 1     15 Width 4ft   6014570.20304 2115942.2831 37.7907930492013 -122.393458763924 (37.7907930492013, -122.393458763924)
119338 113383 2 97 146 CASTENADA AVE 2 1 1 1     7 3x3   5994461.0 2101055.0 37.7487786662853 -122.46195512222401 (37.7487786662853, -122.461955122224)
34571 206020 2 97 146 Castenada Ave 1 2 1 1     6 Width 3ft   5994480.54768 2101060.81011 37.7487957447457 -122.46188794817499 (37.7487957447457, -122.461887948175)
Powered by Datasette · Query took 99.551ms · Data source: data.sfgov.org