trees

Custom SQL query returning 48 rows (hide)

Query parameters

This data as json, CSV

rowidTreeIDqLegalStatus_idqSpecies_idqAddressSiteOrderqSiteInfoPlantTypeqCaretaker_idqCareAssistantPlantDateDBHPlotSizePermitNotesXCoordYCoordLatitudeLongitudeLocationFire Prevention DistrictsPolice DistrictsSupervisor DistrictsZip CodesNeighborhoods (old)
102329 91788 1 148 830X Harrison St 8 Sidewalk: Curb side : Cutout Tree 4   03/07/2007 12:00:00 AM 3 3x3   6012494.965717 2112152.388469 37.7802713613915 -122.400372717325 (37.7802713613915, -122.400372717325) 6 2 9 28856 34
127080 112029 1 6 2101x 22nd Ave 9 Sidewalk: Curb side : Cutout Tree 4   07/23/2015 12:00:00 AM 3 9x9   6011761 2103726 37.75709344993 -122.402319220858 (37.75709344993, -122.402319220858) 10 3 8 28856 29
129965 112024 1 93 2101x 22nd Ave 4 Sidewalk: Curb side : Cutout Tree 4       5x5   6011761 2103726 37.75709344993 -122.402319220858 (37.75709344993, -122.402319220858) 10 3 8 28856 29
171218 107868 1 27 830X Harrison St 1 Sidewalk: Curb side : Cutout Tree 4           6012494.96542 2112152.38808 37.7802713603069 -122.400372718325 (37.7802713603069, -122.400372718325) 6 2 9 28856 34
174726 112028 1 16 2101x 22nd Ave 8 Sidewalk: Curb side : Cutout Tree 4   07/23/2015 12:00:00 AM 3 9x9   6011761 2103726 37.75709344993 -122.402319220858 (37.75709344993, -122.402319220858) 10 3 8 28856 29
187598 112025 1 6 2101x 22nd Ave 5 Sidewalk: Curb side : Cutout Tree 4   07/23/2015 12:00:00 AM 3 5x5   6011761 2103726 37.75709344993 -122.402319220858 (37.75709344993, -122.402319220858) 10 3 8 28856 29
8452 116055 1 11 650x Kansas St 11 Sidewalk: Curb side : Cutout Tree 4 DPW for City Agency 06/08/2020 12:00:00 AM 3 4x4   6011513.13975 2105199.40577 37.7611252557522 -122.403280067548 (37.7611252557522, -122.403280067548) 10 3 8 28856 29
8962 116061 1 70 2100x 19th St 5 Sidewalk: Curb side : Cutout Tree 4 DPW for City Agency   16 3x3   6011385.89017 2105128.48272 37.7609234092204 -122.403715181115 (37.7609234092204, -122.403715181115) 10 3 8 28856 29
14250 116051 1 14 650x Kansas St 7 Sidewalk: Curb side : Cutout Tree 4 DPW for City Agency   3 4x4   6011500.28754 2105307.13541 37.7614203394907 -122.403332096897 (37.7614203394907, -122.403332096897) 10 3 8 28856 29
33876 115549 1 31 925x Minnesota St 1 Sidewalk: Curb side : Cutout Tree 4 DPW for City Agency   18 20x7   6015281.58054 2104112.34112 37.7583501556473 -122.390170593412 (37.7583501556473, -122.390170593412) 10 3 8 28856 29
35366 116063 1 437 2100x 19th St 7 Sidewalk: Curb side : Cutout Tree 4 DPW for City Agency   19 3x3   6011332.66531 2105125.78364 37.7609130247313 -122.403899073603 (37.7609130247313, -122.403899073603) 10 3 8 28856 29
35970 122754 1 57 693 Vermont St 4 Sidewalk: Curb side : Cutout Tree 4 DPW for City Agency   16     6011277.36342 2105334.1858 37.7614821606899 -122.404105006665 (37.7614821606899, -122.404105006665) 10 3 8 28856 29
36749 122752 1 97 693 Vermont St 6 Sidewalk: Curb side : Cutout Tree 4 DPW for City Agency   18     6011278.80569 2105286.3398 37.7613508668666 -122.404096651066 (37.7613508668666, -122.404096651066) 10 3 8 28856 29
38426 115550 1 31 925x Minnesota St 2 Sidewalk: Curb side : Cutout Tree 4 DPW for City Agency   18 20x7   6015279.22506 2104155.94994 37.7584697654838 -122.390181786362 (37.7584697654838, -122.390181786362) 10 3 8 28856 29
40315 116056 1 11 650x Kansas St 12 Sidewalk: Curb side : Cutout Tree 4 DPW for City Agency 03/30/2018 12:00:00 AM 23 4x4   6011515.19198 2105171.68257 37.7610492486475 -122.403271019449 (37.7610492486475, -122.403271019449) 10 3 8 28856 29
41878 116060 1 57 2100x 19th St 4 Sidewalk: Curb side : Cutout Tree 4 DPW for City Agency   7 3x3   6011408.71891 2105130.5396 37.7609303321981 -122.403636370817 (37.7609303321981, -122.403636370817) 10 3 8 28856 29
58864 116052 1 11 650x Kansas St 8 Sidewalk: Curb side : Cutout Tree 4 DPW for City Agency 01/23/2018 12:00:00 AM 3 4x4   6011506.55629 2105277.69862 37.7613398627543 -122.403308344903 (37.7613398627543, -122.403308344903) 10 3 8 28856 29
61919 43305 1 97 693 Vermont St 10 Sidewalk: Curb side : Cutout Tree 4 DPW for City Agency 07/12/2000 12:00:00 AM 6   Permit Number 43072 6011285.67007 2105193.27319 37.7610957103087 -122.4040663601 (37.7610957103087, -122.4040663601) 10 3 8 28856 29
73796 115552 1 50 925x Minnesota St 4 Sidewalk: Curb side : Cutout Tree 4 DPW for City Agency   6 15x7   6015276.56251 2104229.20593 37.7586707630633 -122.390196112573 (37.7586707630633, -122.390196112573) 10 3 8 28856 29
79109 116057 1 22 2100x 19th St 1 Sidewalk: Curb side : Cutout Tree 4 DPW for City Agency   2 3x3   6011480.97635 2105135.37266 37.760947638753 -122.40338680266 (37.760947638753, -122.40338680266) 10 3 8 28856 29
89512 116065 1 51 693 Vermont St 2 Sidewalk: Curb side : Cutout Tree 4 DPW for City Agency 03/30/2018 12:00:00 AM 3 8x7   6011274.01561 2105377.63125 37.7616012651139 -122.404119643106 (37.7616012651139, -122.404119643106) 10 3 8 28856 29
89640 116047 1 89 650x Kansas St 3 Sidewalk: Curb side : Cutout Tree 4 DPW for City Agency   11 5x12   6011496.1211 2105415.82819 37.761718552879 -122.403354153666 (37.761718552879, -122.403354153666) 10 3 8 28856 29
106425 116064 1 51 693 Vermont St 1 Sidewalk: Curb side : Cutout Tree 4 DPW for City Agency 03/30/2018 12:00:00 AM 3 8x7   6011272.30638 2105412.17877 37.7616960293658 -122.404127986133 (37.7616960293658, -122.404127986133) 10 3 8 28856 29
110109 116049 1 57 650x Kansas St 5 Sidewalk: Curb side : Cutout Tree 4 DPW for City Agency   5 4x4   6011498.3385 2105356.0244 37.7615544688802 -122.403342277248 (37.7615544688802, -122.403342277248) 10 3 8 28856 29
112770 116059 1 22 2100x 19th St 3 Sidewalk: Curb side : Cutout Tree 4 DPW for City Agency   2 3x3   6011431.5308 2105131.75607 37.7609349466036 -122.403557559651 (37.7609349466036, -122.403557559651) 10 3 8 28856 29
114573 43306 1 315 693 Vermont St 12 Sidewalk: Curb side : Cutout Tree 4 DPW for City Agency 07/12/2000 12:00:00 AM 22   Permit Number 43072 6011289.47877 2105149.93268 37.7609769197604 -122.404050137204 (37.7609769197604, -122.404050137204) 10 3 8 28856 29
117414 122753 1 51 693 Vermont St 5 Sidewalk: Curb side : Cutout Tree 4 DPW for City Agency   15     6011277.81019 2105311.62173 37.7614202297665 -122.404101873421 (37.7614202297665, -122.404101873421) 10 3 8 28856 29
120995 116062 1 38 2100x 19th St 6 Sidewalk: Curb side : Cutout Tree 4 DPW for City Agency   22 3x3   6011361.02056 2105129.82914 37.7609257168785 -122.403801289392 (37.7609257168785, -122.403801289392) 10 3 8 28856 29
122926 122750 1 97 693 Vermont St 8 Sidewalk: Curb side : Cutout Tree 4 DPW for City Agency   9     6011285.1392 2105241.40164 37.7612278306072 -122.404071583333 (37.7612278306072, -122.404071583333) 10 3 8 28856 29
129944 115551 1 31 925x Minnesota St 3 Sidewalk: Curb side : Cutout Tree 4 DPW for City Agency   20 18x7   6015277.41921 2104189.44931 37.7585616474178 -122.390190372193 (37.7585616474178, -122.390190372193) 10 3 8 28856 29
134813 122751 1 38 693 Vermont St 7 Sidewalk: Curb side : Cutout Tree 4 DPW for City Agency   18     6011280.99043 2105260.13165 37.7612790272197 -122.404087250433 (37.7612790272197, -122.404087250433) 10 3 8 28856 29
143067 122749 1 97 693 Vermont St 9 Sidewalk: Curb side : Cutout Tree 4 DPW for City Agency   5     6011285.50671 2105214.92948 37.7611551645106 -122.404068449214 (37.7611551645106, -122.404068449214) 10 3 8 28856 29
147370 116046 1 14 650x Kansas St 2 Sidewalk: Curb side : Cutout Tree 4 DPW for City Agency   4 5x15   6011495.20108 2105434.89797 37.7617708628477 -122.40335867726 (37.7617708628477, -122.40335867726) 10 3 8 28856 29
150345 116048 1 62 650x Kansas St 4 Sidewalk: Curb side : Cutout Tree 4 DPW for City Agency   9 4x4   6011498.51602 2105372.79225 37.7616005195649 -122.403342842915 (37.7616005195649, -122.403342842915) 10 3 8 28856 29
164578 116058 1 22 2100x 19th St 2 Sidewalk: Curb side : Cutout Tree 4 DPW for City Agency   2 3x3   6011458.59484 2105134.56728 37.760944177262 -122.403464154268 (37.760944177262, -122.403464154268) 10 3 8 28856 29
165196 43304 1 38 693 Vermont St 11 Sidewalk: Curb side : Cutout Tree 4 DPW for City Agency 07/12/2000 12:00:00 AM 19   Permit Number 43072 6011287.96925 2105166.37556 37.7610219838923 -122.404056515205 (37.7610219838923, -122.404056515205) 10 3 8 28856 29
176047 116054 1 38 650x Kansas St 10 Sidewalk: Curb side : Cutout Tree 4 DPW for City Agency   23 4x4   6011511.93551 2105220.59815 37.7611833780414 -122.403285723377 (37.7611833780414, -122.403285723377) 10 3 8 28856 29
180684 116050 1 14 650x Kansas St 6 Sidewalk: Curb side : Cutout Tree 4 DPW for City Agency   3 4x4   6011499.79329 2105331.08163 37.7614860628578 -122.403335490949 (37.7614860628578, -122.403335490949) 10 3 8 28856 29
184196 122755 1 57 693 Vermont St 3 Sidewalk: Curb side : Cutout Tree 4 DPW for City Agency   14     6011274.22678 2105356.76628 37.7615439863765 -122.404117444276 (37.7615439863765, -122.404117444276) 10 3 8 28856 29
184781 116053 1 38 650x Kansas St 9 Sidewalk: Curb side : Cutout Tree 4 DPW for City Agency   11 4x4   6011508.10962 2105241.51829 37.7612406063998 -122.403300427289 (37.7612406063998, -122.403300427289) 10 3 8 28856 29
2079 263595 1 27 830x Harrison St 6 Sidewalk: Curb side : Cutout Tree 4 Private     3x3   6012495 2112152 37.7802702966571 -122.40037257143 (37.7802702966571, -122.40037257143) 6 2 9 28856 34
4032 263594 1 27 830x Harrison St 5 Sidewalk: Curb side : Cutout Tree 4 Private     3x3   6012495 2112152 37.7802702966571 -122.40037257143 (37.7802702966571, -122.40037257143) 6 2 9 28856 34
4900 263589 1 19 800 Harrison St 2 Sidewalk: Curb side : Cutout Tree 4 Private     3x3   6012532 2112188 37.7803712075622 -122.400247099708 (37.7803712075622, -122.400247099708) 6 2 9 28856 34
4935 263596 1 27 830x Harrison St 7 Sidewalk: Curb side : Cutout Tree 4 Private     3x3   6012495 2112152 37.7802702966571 -122.40037257143 (37.7802702966571, -122.40037257143) 6 2 9 28856 34
7643 263592 1 27 830x Harrison St 3 Sidewalk: Curb side : Cutout Tree 4 Private     3x3   6012495 2112152 37.7802702966571 -122.40037257143 (37.7802702966571, -122.40037257143) 6 2 9 28856 34
10051 263590 1 27 830x Harrison St 1 Sidewalk: Curb side : Cutout Tree 4 Private     3x3   6012495 2112152 37.7802702966571 -122.40037257143 (37.7802702966571, -122.40037257143) 6 2 9 28856 34
16157 263597 1 27 830x Harrison St 8 Sidewalk: Curb side : Cutout Tree 4 Private 03/07/2007 12:00:00 AM   3x3   6012495 2112152 37.7802702966571 -122.40037257143 (37.7802702966571, -122.40037257143) 6 2 9 28856 34
18291 263593 1 27 830x Harrison St 4 Sidewalk: Curb side : Cutout Tree 4 Private     3x3   6012495 2112152 37.7802702966571 -122.40037257143 (37.7802702966571, -122.40037257143) 6 2 9 28856 34