trees

Custom SQL query returning 101 rows (hide)

Query parameters

rowidTreeIDqLegalStatus_idqSpecies_idqAddressSiteOrderqSiteInfoPlantTypeqCaretaker_idqCareAssistantPlantDateDBHPlotSizePermitNotesXCoordYCoordLatitudeLongitudeLocationFire Prevention DistrictsPolice DistrictsSupervisor DistrictsZip CodesNeighborhoods (old)
64702 200418 1 11 975 Minna St 1 : Tree 2     6 Width 3ft   6007829.74839 2109969.8332 37.7740173286603 -122.416357268587 (37.7740173286603, -122.416357268587) 8 2 9 28853 34
66458 200409 1 11 342 09th St 4 : Tree 2     6 Width 3ft   6009338.84231 2109650.1648 37.773224339773 -122.411114450371 (37.773224339773, -122.411114450371) 8 2 9 28853 34
69001 246895 1 11 550 Frederick St 2 : Tree 2     11 Width 3ft   5996881.3506 2107395.29501 37.7663265639355 -122.454043456049 (37.7663265639355, -122.454043456049) 15 5 11 29492 8
70347 177216 1 11 3602 Alemany Blvd 4 : Tree 2     9 Width 3ft   5993403.40349 2087610.58828 37.7118026809134 -122.464636139668 (37.7118026809134, -122.464636139668) 9 8 4 64 24
70558 201110 1 11 3601 03rd St 3 : Tree 2     4 Width 3ft   6015895.70555 2098520.88145 37.7430312199266 -122.387656551215 (37.7430312199266, -122.387656551215) 10 3 8 58 1
70949 249371 1 11 651 Jones St 3 : Tree 2     7 Width 3ft   6008791.00522 2114822.15821 37.7873946631776 -122.41337532982 (37.7873946631776, -122.41337532982) 5 1 10 28852 36
72476 200387 1 11 172 Clara St 2 : Tree 2     6 Width 2ft   6012177.4749 2112141.69515 37.7802242902546 -122.401470319517 (37.7802242902546, -122.401470319517) 6 2 9 28856 34
72774 200420 1 11 975 Minna St 3 : Tree 2     6 Width 3ft   6007869.09874 2110009.15543 37.7741275109008 -122.416223934192 (37.7741275109008, -122.416223934192) 8 2 9 28853 34
73333 129905 1 11 639 Buchanan St 1 : Tree 2     12 Width 4ft   6004490.10271 2110798.8146 37.7761051434844 -122.427968759073 (37.7761051434844, -122.427968759073) 7 9 11 28852 10
74297 191601 1 11 20 Diana St 1 : Tree 2     13 Width 3ft   6013324.06889 2094140.34911 37.7308604059659 -122.396241685406 (37.7308604059659, -122.396241685406) 10 3 8 58 1
74956 249383 1 11 425 Eddy St 1 : Tree 2     8 Width 3ft   6008392.94969 2113449.2104 37.7836025233747 -122.414655327681 (37.7836025233747, -122.414655327681) 7 10 9 28852 36
75301 249401 1 11 245 Hyde St 1 : Tree 2     2 Width 3ft   6008032.41291 2113294.89436 37.7831585460618 -122.415891719247 (37.7831585460618, -122.415891719247) 7 10 9 28852 36
76721 201126 1 11 1401 Cesar Chavez St 1 : Tree 2     9 Width 4ft   6014417.51675 2101037.44275 37.7498591786744 -122.39294379862 (37.7498591786744, -122.39294379862) 10 3 8 58 1
76885 191589 1 11 750 Phelps St 37 : Tree 2     4 Width 2ft   6015171.71316 2097880.19375 37.7412318941435 -122.390115192457 (37.7412318941435, -122.390115192457) 10 3 8 58 1
77053 249432 1 11 535 Eddy St 2 : Tree 2     13 Width 3ft   6007912.19308 2113383.89616 37.7833961640536 -122.416313938355 (37.7833961640536, -122.416313938355) 7 10 9 28852 36
78384 200385 1 11 199x Shipley St 7 : Tree 2     8 Width 2ft   6011964.68375 2112165.07908 37.7802766218148 -122.402208110717 (37.7802766218148, -122.402208110717) 6 2 9 28856 34
78884 249361 1 11 600 Leavenworth St 1 : Tree 2     1 Width 3ft   6008388.29981 2114566.97236 37.7866713663475 -122.414750545217 (37.7866713663475, -122.414750545217) 5 1 10 28858 36
79224 191583 1 11 750 Phelps St 31 : Tree 2     10 Width 2ft   6015226.42584 2097953.59483 37.741436472805 -122.389931139928 (37.741436472805, -122.389931139928) 10 3 8 58 1
79243 246834 1 11 200 Baker St 6 : Tree 2     16 Width 3ft   6000783.10255 2109861.58613 37.773321333458 -122.440724988475 (37.773321333458, -122.440724988475) 15 5 11 29492 10
79459 177215 1 11 3602 Alemany Blvd 3 : Tree 2     7 Width 3ft   5993434.69457 2087605.54338 37.7117906327114 -122.464527623844 (37.7117906327114, -122.464527623844) 9 8 4 64 24
79731 201143 1 11 3150 03rd St 11 : Tree 2     5 Width 2ft   6015947.24975 2100770.31272 37.7492105480338 -122.387635229175 (37.7492105480338, -122.387635229175) 10 3 8 58 1
80237 200416 1 11 202 11th St 1 : Tree 2     11 Width 3ft   6008160.82212 2109555.83815 37.7728992078593 -122.415182713517 (37.7728992078593, -122.415182713517) 8 2 9 28853 34
81268 191580 1 11 750 Phelps St 28 : Tree 2     4 Width 4ft   6015252.40332 2097986.02627 37.7415269634907 -122.389843582826 (37.7415269634907, -122.389843582826) 10 3 8 58 1
81791 201149 1 11 3450 03rd St 1 : Tree 2     9 Width 3ft   6016017.10243 2099552.94124 37.7458717672817 -122.387308767189 (37.7458717672817, -122.387308767189) 10 3 8 58 1
82482 201128 1 11 1401 Cesar Chavez St 3 : Tree 2     8 Width 4ft   6014473.96426 2101041.60815 37.7498737512866 -122.392748890363 (37.7498737512866, -122.392748890363) 10 3 8 58 1
82684 246888 1 11 811 Stanyan St 1 : Tree 2     11 Width 3ft   5997111.16957 2107712.02155 37.7672093888359 -122.453271427639 (37.7672093888359, -122.453271427639) 15 5 11 29492 8
83152 201169 1 11 1601 Evans Ave 31 : Tree 2     9 Width 4ft   6015248.38904 2098778.84927 37.743703669084 -122.38991283062 (37.743703669084, -122.38991283062) 10 3 8 58 1
84074 201152 1 11 3450 03rd St 4 : Tree 2     6 Width 3ft   6016021.71078 2099488.71355 37.7456956665211 -122.387288352568 (37.7456956665211, -122.387288352568) 10 3 8 58 1
84633 200377 1 11 648 Hawthorne St 8 : Tree 2     12 Width 3ft   6013578.3543 2113441.5734 37.7838715222907 -122.396715152384 (37.7838715222907, -122.396715152384) 6 2 9 28856 6
85360 191593 1 11 1470 Phelps St 1 : Tree 2     16 Width 3ft   6013866.02764 2096131.49472 37.7363578249495 -122.394507403991 (37.7363578249495, -122.394507403991) 10 3 8 58 1
85490 246858 1 11 1198 Oak St 1 : Tree 1     5 Width 4ft   6001462.57137 2109763.81432 37.7730915476574 -122.438367610872 (37.7730915476574, -122.438367610872) 15 5 11 29492 10
85545 201151 1 11 3450 03rd St 3 : Tree 2     10 Width 3ft   6016020.01322 2099524.28908 37.7457932555697 -122.38729670369 (37.7457932555697, -122.38729670369) 10 3 8 58 1
86238 191561 1 11 1601 Evans Ave 35 : Tree 2     13 Width 4ft   6015295.46676 2098743.928 37.7436103932138 -122.389747607174 (37.7436103932138, -122.389747607174) 10 3 8 58 1
87644 228893 1 11 7 Octavia St 5 : Tree 2     11 Width 3ft   6005665.12623 2109343.19897 37.7721747805788 -122.423800508381 (37.7721747805788, -122.423800508381) 7 9 11 28852 10
87751 249369 1 11 651 Jones St 1 : Tree 2     9 Width 3ft   6008783.94148 2114861.19472 37.7875014513852 -122.413402530727 (37.7875014513852, -122.413402530727) 5 1 10 28852 36
87856 247193 1 11 98 Broderick St 2 : Tree 2     1 Width 3ft   6001379.15483 2108959.66255 37.7708788026556 -122.438598528898 (37.7708788026556, -122.438598528898) 15 5 11 29492 9
88057 200394 1 11 460 Bryant St 6 : Tree 2     2 Width 3ft   6014048.55441 2112781.28692 37.7820846854009 -122.395042158886 (37.7820846854009, -122.395042158886) 6 2 9 28856 6
88392 191571 1 11 1620 Innes Ave 2 : Tree 2     7 Width 3ft   6015092.65842 2097573.63584 37.7403857642898 -122.390367124069 (37.7403857642898, -122.390367124069) 10 3 8 58 1
88576 200383 1 11 199x Shipley St 5 : Tree 2     7 Width 2ft   6011917.22613 2112117.03487 37.780142054444 -122.40236891041 (37.780142054444, -122.40236891041) 6 2 9 28856 34
89639 191572 1 11 1620 Innes Ave 3 : Tree 2     9 Width 3ft   6015078.87545 2097583.46465 37.7404119876131 -122.390415467114 (37.7404119876131, -122.390415467114) 10 3 8 58 1
90028 250488 1 11 236 El Camino Del Mar 1 : Tree 2     4 Width 3ft   5987839.39614 2115354.89245 37.7876587769797 -122.48590177317 (37.7876587769797, -122.48590177317) 11 6 1 55 33
90414 201138 1 11 1101 Cesar Chavez St 10 : Tree 2     2 Width 3ft   6015541.39338 2101061.41516 37.7499873653311 -122.389059021452 (37.7499873653311, -122.389059021452) 10 3 8 58 1
91494 228867 1 11 152 Church St 1 : Tree 2     5 Width 4ft   6004087.53169 2108047.65842 37.7685283570331 -122.429165148753 (37.7685283570331, -122.429165148753) 7 9 5 28862 3
91569 201112 1 11 3601 03rd St 16 : Tree 2     5 Width 3ft   6015994.2321 2098853.94308 37.7439511957858 -122.387339098625 (37.7439511957858, -122.387339098625) 10 3 8 58 1
91626 201130 1 11 1301 Cesar Chavez St 1 : Tree 2     2 Width 3ft   6014796.06601 2101067.99552 37.7499640899872 -122.391636883131 (37.7499640899872, -122.391636883131) 10 3 8 58 1
92222 201088 1 11 259 Missouri St 1 : Tree 2     11 Width 3ft   6013493.57368 2105881.3561 37.7631081493476 -122.396478351907 (37.7631081493476, -122.396478351907) 14 3 8 28856 29
92649 192631 1 11 2 Garlington Ct 1 : Tree 2     15 Width 6ft   6016783.64783 2094408.52472 37.7317886592161 -122.38429991441 (37.7317886592161, -122.38429991441) 10 3 8 58 1
93038 191581 1 11 750 Phelps St 29 : Tree 2     11 Width 4ft   6015243.91638 2097975.462 37.7414974855289 -122.389872190262 (37.7414974855289, -122.389872190262) 10 3 8 58 1
93578 191598 1 11 301 Mendell St 6 : Tree 2     5 Width 3ft   6016898.03582 2097891.47999 37.7413584809142 -122.384146910066 (37.7413584809142, -122.384146910066) 10 3 8 58 1
93896 200373 1 11 648 Hawthorne St 4 : Tree 2     7 Width 3ft   6013641.49544 2113370.03612 37.7836786114195 -122.396491689759 (37.7836786114195, -122.396491689759) 6 2 9 28856 6
94029 228901 1 11 135 Scott St 1 : Tree 2     12 Width 6ft   6002314.12723 2108991.34813 37.7710189458042 -122.435366708107 (37.7710189458042, -122.435366708107) 15 5 11 29492 9
94226 228877 1 11 317 Buchanan St 1 : Tree 2     9 Width 4ft   6004647.56992 2109687.90952 37.7730637766113 -122.427344883161 (37.7730637766113, -122.427344883161) 7 9 11 28852 10
94518 191575 4 11 750 Phelps St 5 : Tree 2     4 Width 3ft   6015519.38239 2098345.71066 37.7425293847338 -122.388945558515 (37.7425293847338, -122.388945558515) 10 3 8 58 1
95016 201134 1 11 1101 Cesar Chavez St 1 : Tree 2     9 Width 3ft   6015207.69874 2101056.74744 37.7499560455385 -122.390212638498 (37.7499560455385, -122.390212638498) 10 3 8 58 1
95172 228921 1 11 198 Scott St 2 : Tree 2     13 Width 3ft   6002352.8945 2109083.3807 37.7712738460493 -122.435239195042 (37.7712738460493, -122.435239195042) 15 5 11 29492 9
95224 249365 1 11 650 Leavenworth St 2 : Tree 2     6 Width 3ft   6008363.1001 2114731.59965 37.7871219770405 -122.414849386115 (37.7871219770405, -122.414849386115) 5 1 10 28858 36
95631 246835 1 11 200 Baker St 7 : Tree 2     12 Width 3ft   6000778.83729 2109894.07968 37.7734103096702 -122.440742073802 (37.7734103096702, -122.440742073802) 15 5 11 29492 10
95911 228895 1 11 125 Haight St 1 : Tree 2     2 Width 3ft   6005420.08779 2109571.63631 37.7727881784747 -122.424664371072 (37.7727881784747, -122.424664371072) 7 9 11 28852 10
96379 201150 1 11 3450 03rd St 2 : Tree 2     7 Width 3ft   6016018.6785 2099537.94473 37.7458306772468 -122.387302271397 (37.7458306772468, -122.387302271397) 10 3 8 58 1
96589 246836 1 11 1377 Fell St 4 : Tree 2     11 Width 3ft   6001045.69179 2109998.49138 37.7737121913922 -122.439826475826 (37.7737121913922, -122.439826475826) 15 5 11 29492 10
96629 201137 1 11 1101 Cesar Chavez St 9 : Tree 2     9 Width 3ft   6015512.83936 2101059.00392 37.749979161706 -122.389157595246 (37.749979161706, -122.389157595246) 10 3 8 58 1
98361 201129 1 11 1401 Cesar Chavez St 4 : Tree 2     12 Width 4ft   6014506.80951 2101043.19718 37.749879938626 -122.392635420204 (37.749879938626, -122.392635420204) 10 3 8 58 1
99409 201161 1 11 1601 Evans Ave 13 : Tree 2     11 Width 5ft   6014928.29138 2099014.96701 37.7443342422344 -122.391036160304 (37.7443342422344, -122.391036160304) 10 3 8 58 1
100876 208327 1 11 75 Majestic Ave 2 : Tree 2     10 Width 3ft   5997181.75563 2089466.45636 37.7171155652953 -122.45171096898 (37.7171155652953, -122.45171096898) 9 8 6 28861 24
101472 191563 1 11 1610 Innes Ave 2 : Tree 2     7 Width 3ft   6015314.79253 2097408.3563 37.739944260112 -122.389587525137 (37.739944260112, -122.389587525137) 10 3 8 58 1
102309 228881 1 11 323 Buchanan St 1 : Tree 2     7 Width 4ft   6004638.43173 2109748.282 37.7732290279252 -122.427380794902 (37.7732290279252, -122.427380794902) 7 9 11 28852 10
103463 201079 1 11 1106 Wisconsin St 3 : Tree 2     5 Width 3ft   6012790.90295 2102299.32188 37.7532335393167 -122.398657283334 (37.7532335393167, -122.398657283334) 10 3 8 28856 29
103585 201153 1 11 3450 03rd St 5 : Tree 2     11 Width 3ft   6016022.20317 2099473.20438 37.7456531088104 -122.387285568286 (37.7456531088104, -122.387285568286) 10 3 8 58 1
104188 191587 1 11 750 Phelps St 35 : Tree 2     13 Width 2ft   6015188.55124 2097905.48754 37.7413022795673 -122.390058738419 (37.7413022795673, -122.390058738419) 10 3 8 58 1
105475 187516 1 11 299 Lauren Ct 2 : Tree 2     5 Width 2ft   6012587.97083 2088132.1806 37.7143222062682 -122.39836510978 (37.7143222062682, -122.39836510978) 10 3 8 309 1
105763 228869 1 11 138 Church St 1 : Tree 2     15 Width 4ft   6004086.48121 2108116.61202 37.7687176274439 -122.429173699533 (37.7687176274439, -122.429173699533) 7 9 5 28862 3
105832 250064 1 11 1600 Franklin St 2 : Tree 2     2 Width 3ft   6005815.61833 2115637.88062 37.7894669296122 -122.423727587757 (37.7894669296122, -122.423727587757) 13 9 1 28858 41
107697 228920 1 11 198 Scott St 1 : Tree 2     12 Width 3ft   6002351.78865 2109062.83488 37.7712173695093 -122.435241550382 (37.7712173695093, -122.435241550382) 15 5 11 29492 9
108806 228859 1 11 220 Valencia St 2 : Tree 2     10 Width 3ft   6006042.19236 2108323.05651 37.7693949923202 -122.422423704799 (37.7693949923202, -122.422423704799) 8 4 5 28853 19
109243 201127 1 11 1401 Cesar Chavez St 2 : Tree 2     8 Width 4ft   6014448.65855 2101039.67275 37.7498670315541 -122.392836263991 (37.7498670315541, -122.392836263991) 10 3 8 58 1
111797 247191 1 11 1035 Haight St 2 : Tree 2     4 Width 3ft   6001174.20551 2108973.71148 37.7709057166556 -122.439308459119 (37.7709057166556, -122.439308459119) 15 5 11 29492 9
113039 201117 1 11 3401 03rd St 5 : Tree 2     7 Width 3ft   6016111.48727 2099406.92968 37.7454760763529 -122.386972213001 (37.7454760763529, -122.386972213001) 10 3 8 58 1
113489 201168 1 11 1601 Evans Ave 30 : Tree 2     10 Width 4ft   6015234.89257 2098788.25791 37.7437287547683 -122.389960155661 (37.7437287547683, -122.389960155661) 10 3 8 58 1
113867 249367 1 11 775 Post St 2 : Tree 2     9 Width 3ft   6008467.38868 2114846.99121 37.7874446735824 -122.414496737661 (37.7874446735824, -122.414496737661) 5 1 10 28858 36
114353 228855 1 11 27 Duboce Ave 2 : Tree 2     4 Width 3ft   6006522.00776 2108488.8811 37.7698773625703 -122.420775815873 (37.7698773625703, -122.420775815873) 8 4 7 28853 19
114598 201155 1 11 3450 03rd St 8 : Tree 2     11 Width 3ft   6016026.02144 2099329.8922 37.7452598145868 -122.387262370276 (37.7452598145868, -122.387262370276) 10 3 8 58 1
115431 191569 1 11 1610 Innes Ave 8 : Tree 2     7 Width 3ft   6015206.39657 2097489.64193 37.7401614427971 -122.389967993234 (37.7401614427971, -122.389967993234) 10 3 8 58 1
115940 228892 1 11 7 Octavia St 4 : Tree 2     10 Width 3ft   6005660.94674 2109362.95512 37.7722287902691 -122.423816370626 (37.7722287902691, -122.423816370626) 7 9 11 28852 10
116539 228880 1 11 321 Buchanan St 1 : Tree 2     6 Width 4ft   6004639.99601 2109734.21898 37.7731905027662 -122.427374381848 (37.7731905027662, -122.427374381848) 7 9 11 28852 10
116576 228894 1 11 155 Haight St 3 : Tree 2     3 Width 3ft   6005394.90252 2109564.77801 37.7727679248183 -122.424751001863 (37.7727679248183, -122.424751001863) 7 9 11 28852 10
118377 200378 1 11 351 Saint Francis Pl 2 : Tree 2     12 Width 1ft   6013252.34045 2113183.85479 37.7831457361415 -122.397824963452 (37.7831457361415, -122.397824963452) 6 2 9 28856 6
119136 200390 1 11 187 Clara St 3 : Tree 2     9 Width 2ft   6012032.33179 2111995.80249 37.7798156032445 -122.40196218033 (37.7798156032445, -122.40196218033) 6 2 9 28856 34
121286 200395 1 11 460 Bryant St 7 : Tree 2     1 Width 3ft   6014040.62231 2112770.68821 37.782055142674 -122.395068857958 (37.782055142674, -122.395068857958) 6 2 9 28856 6
122248 249557 2 11 1450 Franklin St 3 : Tree 2   04/05/2017 12:00:00 AM 3 Width 4ft Permit Number 770925 6005881.27559 2115126.52616 37.7880665835567 -122.423464052238 (37.7880665835567, -122.423464052238) 13 9 1 28858 41
122409 200381 1 11 199x Shipley St 3 : Tree 2     9 Width 2ft   6011884.78691 2112090.46714 37.7800672947149 -122.402479264412 (37.7800672947149, -122.402479264412) 6 2 9 28856 34
123183 228857 1 11 6 Valencia St 1 : Tree 2     11 Width 3ft   6005993.52497 2109299.72249 37.7720739377994 -122.422661457656 (37.7720739377994, -122.422661457656) 8 2 9 28853 19
123309 201136 1 11 1101 Cesar Chavez St 5 : Tree 2     9 Width 3ft   6015362.2226 2101054.57526 37.749958650868 -122.389678130935 (37.749958650868, -122.389678130935) 10 3 8 58 1
123435 249436 1 11 900 Ellis St 1 : Tree 2     8 Width 4ft   6006443.61681 2113576.67266 37.7838427907554 -122.421408338717 (37.7838427907554, -122.421408338717) 7 9 11 28858 41
125193 129903 1 11 629 Buchanan St 1 : Tree 2     14 Width 4ft   6004507.99769 2110701.28424 37.7758383613946 -122.427899904274 (37.7758383613946, -122.427899904274) 7 9 11 28852 10
125373 249368 1 11 775 Post St 3 : Tree 2     11 Width 3ft   6008490.68924 2114849.00143 37.7874515021237 -122.414416264517 (37.7874515021237, -122.414416264517) 5 1 10 28858 36
125423 246899 1 11 550 Frederick St 6 : Tree 2     10 Width 3ft   5996816.52138 2107386.41612 37.7662984673195 -122.454267045507 (37.7662984673195, -122.454267045507) 15 5 11 29492 8
125733 246829 1 11 200 Baker St 1 : Tree 2     13 Width 4ft   6000807.85499 2109696.15357 37.7728685068193 -122.440627498368 (37.7728685068193, -122.440627498368) 15 5 11 29492 10
125906 200374 1 11 648 Hawthorne St 5 : Tree 2     11 Width 3ft   6013630.8496 2113384.10543 37.7837166500571 -122.39652950713 (37.7837166500571, -122.39652950713) 6 2 9 28856 6
126672 208329 1 11 18 Rossmoor Dr 1 : Tree 2     4 Width 3ft   5991167.98634 2094343.99841 37.7301618368806 -122.47285295472 (37.7301618368806, -122.47285295472) 9 8 4 64 40
127072 246842 1 11 301 Broderick St 4 : Tree 14     15 Width 4ft   6001208.43411 2109888.06605 37.7734182533891 -122.439255609578 (37.7734182533891, -122.439255609578) 15 5 11 29492 10
127508 250100 1 11 1661 Pine St 13 : Tree 2     8 Width 3ft   6006110.55942 2115559.79196 37.7892691623936 -122.422701571021 (37.7892691623936, -122.422701571021) 13 9 1 28858 41