trees

Custom SQL query returning 101 rows (show)

Query parameters

This data as json, CSV

rowidTreeIDqLegalStatus_idqSpecies_idqAddressSiteOrderqSiteInfoPlantTypeqCaretaker_idqCareAssistantPlantDateDBHPlotSizePermitNotesXCoordYCoordLatitudeLongitudeLocationFire Prevention DistrictsPolice DistrictsSupervisor DistrictsZip CodesNeighborhoods (old)
756 124716 1 70 2195 Palou Ave 1 Sidewalk: Curb side : Cutout Tree 2                              
768 20385 1 70 262X Sunset Blvd 31 Sidewalk: Curb side : Cutout Tree 1     12 60                      
1032 39972 7 70 0 Steiner St 2 Sidewalk: Curb side : Cutout Tree 2         Permit Number 41235                    
1631 30310 7 70 228 Jordan Ave 2 Sidewalk: Curb side : Cutout Tree 2         Permit Number 8                    
1923 20027 1 70 100 STAIRWAY48 11 Sidewalk: Curb side : Cutout Tree 1     6 10ST                      
2304 19829 1 70 100 STAIRWAY25 13 Sidewalk: Curb side : Cutout Tree 1     6 60X                      
3125 20020 1 70 100 STAIRWAY48 4 Sidewalk: Curb side : Cutout Tree 1     6 10ST                      
4411 20021 1 70 100 STAIRWAY48 5 Sidewalk: Curb side : Cutout Tree 1     12 10ST                      
4760 20025 1 70 100 STAIRWAY48 9 Sidewalk: Curb side : Cutout Tree 1     12 10ST                      
6048 19828 1 70 100 STAIRWAY25 12 Sidewalk: Curb side : Cutout Tree 1     6 60X                      
7821 19789 1 70 100 STAIRWAY19 11 Sidewalk: Curb side : Cutout Tree 1     18 50ST                      
8386 20019 1 70 100 STAIRWAY48 3 Sidewalk: Curb side : Cutout Tree 1     6 10ST                      
8416 20389 1 70 262X Sunset Blvd 35 Sidewalk: Curb side : Cutout Tree 1     12 60                      
9682 19808 1 70 100 STAIRWAY23 3 Sidewalk: Curb side : Cutout Tree 1     12 60ST                      
10444 20024 1 70 100 STAIRWAY48 8 Sidewalk: Curb side : Cutout Tree 1     12 10ST                      
11795 20386 1 70 262X Sunset Blvd 32 Sidewalk: Curb side : Cutout Tree 1     12 60                      
12119 20453 1 70 495X Sunset Blvd 18 Sidewalk: Curb side : Cutout Tree 1     12 60                      
12733 102843 4 70 1101X Portola Dr 10 Sidewalk: Property side : Yard Tree 1                              
13471 20029 1 70 100 STAIRWAY50 1 Sidewalk: Curb side : Cutout Tree 1     12 40ST                      
14545 30309 7 70 228 Jordan Ave 1 Sidewalk: Curb side : Cutout Tree 2         Permit Number 8                    
15463 20023 1 70 100 STAIRWAY48 7 Sidewalk: Curb side : Cutout Tree 1     12 10ST                      
15711 20018 1 70 100 STAIRWAY48 2 Sidewalk: Curb side : Cutout Tree 1     12 10ST                      
16079 20022 1 70 100 STAIRWAY48 6 Sidewalk: Curb side : Cutout Tree 1     12 10ST                      
17223 39975 7 70 0 Steiner St 1 Sidewalk: Curb side : Cutout Tree 2         Permit Number 41235                    
17638 20026 1 70 100 STAIRWAY48 10 Sidewalk: Curb side : Cutout Tree 1     6 10ST                      
18796 19809 1 70 100 STAIRWAY23 4 Sidewalk: Curb side : Cutout Tree 1     12 60ST                      
19569 19966 1 70 100 STAIRWAY41 4 Sidewalk: Curb side : Cutout Tree 1     6 25ST                      
385 138469 1 70 1701 PIERCE ST 2 Sidewalk: Curb side : Cutout Tree 2     16 Width 0ft   6002045.7135 2114397.2192 37.7858468609583 -122.43668217767 (37.7858468609583, -122.43668217767) 13 6 1 29490 27
553 12808 1 70 2112 Lake St 1 Sidewalk: Curb side : Cutout Tree 2     14 5   5988878.34651 2114712.3148 37.7859549296707 -122.482260152644 (37.7859549296707, -122.482260152644) 11 6 1 55 33
717 124802 1 70 2720 Filbert St 2 Sidewalk: Curb side : Cutout Tree 2     17 Width 3ft   5999891.10935 2118493.83248 37.7969724043147 -122.444431001117 (37.7969724043147, -122.444431001117) 13 9 1 57 17
1057 124681 1 70 3899 Jackson St 4 Sidewalk: Curb side : Yard Tree 2     15 Width 3ft   5995544.38439 2115777.07447 37.7892639586617 -122.459274773515 (37.7892639586617, -122.459274773515) 11 6 1 54 31
1104 125224 1 70 2285 Clay St 1 Sidewalk: Curb side : Cutout Tree 2     21 Width 4ft   6003837.08538 2116275.37223 37.7911054341186 -122.430618599767 (37.7911054341186, -122.430618599767) 13 9 1 29490 27
1343 23590 1 70 3251X Van Ness Ave 4 Sidewalk: Curb side : Cutout Tree 1     30 3X3   6005329.9297952 2121916.8669395 37.8066799978444 -122.425855144407 (37.8066799978444, -122.425855144407) 13 1 1 28858 17
1494 21556 1 70 1409 Sutter St 3 Sidewalk: Curb side : Cutout Tree 1     12 3X3   6005783.75363 2114822.50195 37.7872263038018 -122.423779835692 (37.7872263038018, -122.423779835692) 13 9 1 28858 41
1656 125137 1 70 2645 Broderick St 1 Sidewalk: Curb side : Cutout Tree 2     15 Width 4ft   6000115.81749 2117703.18818 37.7948143227728 -122.443596633488 (37.7948143227728, -122.443596633488) 13 9 1 57 27
2052 13108 1 70 1557 Lombard St 1 Sidewalk: Curb side : Cutout Tree 2     60 3x3   6004929.5061 2119810.12 37.8008727786968 -122.427090735634 (37.8008727786968, -122.427090735634) 13 9 1 57 17
2101 117036 4 70 2220x SUTTER ST 4 Sidewalk: Curb side : Cutout Tree 2       3x3   6001781 2114465 37.7860179225956 -122.437602866759 (37.7860179225956, -122.437602866759) 13 6 1 29490 27
2457 115561 1 70 44 21st Ave 1 Sidewalk: Curb side : Cutout Tree 2     19 4x10 Permit Number 777606 5989293.97789 2114922.2794 37.7865556002814 -122.480837576069 (37.7865556002814, -122.480837576069) 11 6 1 55 33
2878 124826 1 70 56 Cervantes Blvd 1 Sidewalk: Curb side : Cutout Tree 2     17 Width 3ft   6001759.52883 2120853.50314 37.8035578671766 -122.438134955373 (37.8035578671766, -122.438134955373) 13 9 1 57 17
3359 250631 1 70 161 28th Ave 2 Sidewalk: Curb side : Yard Tree 2   10/06/2020 12:00:00 AM 3 Width 4ft   5987117.30977 2114718.25139 37.7858686386749 -122.488353213533 (37.7858686386749, -122.488353213533) 11 6 1 55 33
3691 121048 7 70 2652 Polk St 2 Sidewalk: Curb side : Cutout Tree 2 FUF         6006192.78395747 2119877.54417008 37.8011292630692 -122.422724050002 (37.8011292630692, -122.422724050002) 13 9 1 28858 32
3857 104292 7 70 2245 Beach St 2 Sidewalk: Curb side : Cutout Tree 2           5999485.4 2120797.2 37.8032736772553 -122.446000602494 (37.8032736772553, -122.446000602494) 13 9 1 57 17
4435 100789 1 70 29 16th Ave 1 Sidewalk: Curb side : Cutout Tree 2     28 6x25 Permit Number 27110 5990777 2114840 37.7864157730855 -122.475700726719 (37.7864157730855, -122.475700726719) 11 6 1 54 33
4578 79286 1 70 1322 Baker St 2 Sidewalk: Curb side : Cutout Tree 2     15 3x3   6000254.8822 2113507.7337 37.7833026287552 -122.442814041263 (37.7833026287552, -122.442814041263) 15 6 1 29490 13
4794 23518 1 70 2701 Van Ness Ave 1 Sidewalk: Curb side : Cutout Tree 1     20 3X3   6005659.14507 2119690.7477 37.8005862454143 -122.424557378741 (37.8005862454143, -122.424557378741) 13 9 1 57 17
5429 116488 4 70 2149 LYON ST   Sidewalk: Curb side : Cutout Tree 2       3x3   5999319 2116238 37.7907458271484 -122.446248274058 (37.7907458271484, -122.446248274058) 13 6 1 29490 31
5572 250632 1 70 161 28th Ave 3 Sidewalk: Curb side : Yard Tree 2   10/06/2020 12:00:00 AM 3 Width 4ft   5987122.25317 2114703.48842 37.7858283922212 -122.488335025649 (37.7858283922212, -122.488335025649) 11 6 1 55 33
5752 125230 1 70 2300 Octavia St 5 Sidewalk: Curb side : Yard Tree 2     13 Width 4ft   6004620.5622 2117170.01804 37.7936062589738 -122.427971574849 (37.7936062589738, -122.427971574849) 13 9 1 28858 27
6329 123999 1 70 69 06th Ave 2 Sidewalk: Curb side : Cutout Tree 2     26 Width 3ft   5993929.07569 2115077.30992 37.7872495964213 -122.464812666251 (37.7872495964213, -122.464812666251) 11 6 1 54 11
6497 125008 1 70 3790 Fillmore St 1 Sidewalk: Curb side : Cutout Tree 2     15 Width 4ft   6002036.5769 2121760.24067 37.8060632803659 -122.437241182151 (37.8060632803659, -122.437241182151) 13 9 1 57 17
6575 125025 1 70 1442 Jefferson St 1 Sidewalk: Curb side : Cutout Tree 2     10 Width 3ft   6002295.97534 2121603.81012 37.8056485058273 -122.436332290414 (37.8056485058273, -122.436332290414) 13 9 1 57 17
6793 106402 4 70 163 25TH AVE 1 Sidewalk: Curb side : Cutout Tree 2   08/28/2015 12:00:00 AM 18 3x3   5987994.2 2114906.9 37.7864377375077 -122.485333302781 (37.7864377375077, -122.485333302781) 11 6 1 55 33
6833 109426 7 70 132 Locust St   Sidewalk: Curb side : Cutout Tree 2   02/13/2015 12:00:00 AM 3     5997544.3 2115966.4 37.7898985728773 -122.452369007612 (37.7898985728773, -122.452369007612) 11 6 1 54 31
7197 116162 4 70 2569 GREENWICH ST 2 Sidewalk: Curb side : Cutout Tree 2       3x3   6000631 2118874 37.7980584318084 -122.441898109379 (37.7980584318084, -122.441898109379) 13 9 1 57 17
7808 124777 1 70 3060 Scott St 2 Sidewalk: Curb side : Cutout Tree 2     11 Width 3ft   6000983.1166 2118879.20139 37.7980927716149 -122.440680060149 (37.7980927716149, -122.440680060149) 13 9 1 57 17
7932 18681 1 70 155 Richardson Ave 1 Sidewalk: Curb side : Cutout Tree 1     23 3X3   5999165.53622 2119642.20723 37.8000841081609 -122.447024330929 (37.8000841081609, -122.447024330929) 13 9 1 57 17
8376 124888 1 70 3779 Clay St 2 Sidewalk: Curb side : Cutout Tree 2     20 Width 4ft   5996596.43965 2115271.00259 37.7879348499518 -122.455598215684 (37.7879348499518, -122.455598215684) 11 6 1 54 31
8511 60095 1 70 3343 Jackson St 1 Sidewalk: Curb side : Cutout Tree 2 FUF 03/19/1982 12:00:00 AM 10   Permit Number 19596 5998235.21709 2116151.87187 37.7904473875938 -122.449991880723 (37.7904473875938, -122.449991880723) 13 6 1 54 31
8752 7916 7 70 1225 Franklin St 1 Sidewalk: Curb side : Cutout Tree 2     18 4x4   6005951.06937 2114267.1292 37.7857108313539 -122.423161466763 (37.7857108313539, -122.423161466763) 13 9 1 28858 41
8928 116888 1 70 799X Marina Blvd 1 Sidewalk: Curb side : Cutout Tree 2     10 3x3   5999171.6155 2121461.35655 37.8050793482968 -122.447134285827 (37.8050793482968, -122.447134285827) 13 9 1 57 17
8988 125125 1 70 2921 Vallejo St 1 Sidewalk: Curb side : Cutout Tree 2     7 Width 4ft Permit Number 784827 5999533.93344 2117358.43143 37.7938345087112 -122.445585222496 (37.7938345087112, -122.445585222496) 13 9 1 57 27
9096 249565 1 70 1251 Franklin St 3 Sidewalk: Curb side : Cutout Tree 2     25 Width 4ft   6005937.37607 2114355.05187 37.785951472517 -122.423215093814 (37.785951472517, -122.423215093814) 13 9 1 28858 41
9545 125091 1 70 2145 Baker St 2 Sidewalk: Curb side : Cutout Tree 2     14 Width 4ft   5999825.73653 2116332.01645 37.7910328983896 -122.444501757055 (37.7910328983896, -122.444501757055) 13 6 1 29490 27
10310 23457 1 70 2249 Van Ness Ave 1 Sidewalk: Curb side : Cutout Tree 2     14 5x5   6005866.88323 2118164.3475 37.7964068674367 -122.423729927819 (37.7964068674367, -122.423729927819) 13 9 1 28858 27
10456 118326 4 70 3200 CLAY ST 1 Sidewalk: Curb side : Cutout Tree 2       3x3   5999426 2115708 37.7892966967134 -122.445839927288 (37.7892966967134, -122.445839927288) 13 6 1 29490 31
10569 50188 1 70 3134 Baker St 1 Sidewalk: Curb side : Cutout Tree 2   08/20/2003 12:00:00 AM 12   Permit Number 46895 5999411.86905 2119620.94961 37.8000398110413 -122.446170397871 (37.8000398110413, -122.446170397871) 13 9 1 57 17
10690 124815 1 70 3766 Broderick St 2 Sidewalk: Curb side : Cutout Tree 2     11 Width 3ft   5999638.74415 2121468.4947 37.8051256264981 -122.44551825176 (37.8051256264981, -122.44551825176) 13 9 1 57 17
11522 125190 1 70 2809 Buchanan St 1 Sidewalk: Curb side : Cutout Tree 2     14 Width 4ft   6003477.09721 2118091.6097 37.7960719563118 -122.431993895221 (37.7960719563118, -122.431993895221) 13 9 1 57 17
11537 125159 1 70 2695 Vallejo St 2 Sidewalk: Curb side : Cutout Tree 2     13 Width 4ft   6000739.26248 2117523.11724 37.7943554320128 -122.441426505548 (37.7943554320128, -122.441426505548) 13 9 1 57 27
11631 125182 1 70 2409 Vallejo St 1 Sidewalk: Curb side : Cutout Tree 2     15 Width 3ft   6002021.80255 2117699.99218 37.7949140656765 -122.437001442682 (37.7949140656765, -122.437001442682) 13 9 1 57 27
12083 109385 1 70 41X 17th Ave 2 Sidewalk: Curb side : Cutout Tree 2     14 3x3   5990496.07684 2114830.6827 37.7863739000635 -122.476671958733 (37.7863739000635, -122.476671958733) 11 6 1 55 33
12317 124989 1 70 2330 Bay St 1 Sidewalk: Curb side : Cutout Tree 2     16 Width 2ft   5999632.98493 2120193.24081 37.8016237941718 -122.445446428326 (37.8016237941718, -122.445446428326) 13 9 1 57 17
12411 260714 6 70 2290 Lyon St 1 Back Yard : Cutout Tree 2       3x3 Permit Number 784756 5999390 2116615 37.7917850243096 -122.446029746387 (37.7917850243096, -122.446029746387) 13 6 1 29490 27
12665 125122 1 70 2950 Broadway 4 Sidewalk: Curb side : Cutout Tree 2     19 Width 5ft   5999479.00894 2117042.99572 37.7929652698817 -122.445752570148 (37.7929652698817, -122.445752570148) 13 9 1 57 27
13357 125065 1 70 3400 Jackson St 2 Sidewalk: Curb side : Cutout Tree 2     27 Width 3ft   5997930.57243 2116155.0527 37.7904386848382 -122.45104615598 (37.7904386848382, -122.45104615598) 11 6 1 54 31
13825 87087 1 70 20501 Lyon St 1 Sidewalk: Curb side : Cutout Tree 2   12/20/2007 12:00:00 AM 28   Permit Number 50035 5999440.60645 2115900.3485 37.7898256691591 -122.44580322984 (37.7898256691591, -122.44580322984) 13 6 1 29490 27
14009 125068 1 70 2735 Clay St 1 Sidewalk: Curb side : Cutout Tree 2     19 Width 4ft   6001667.65947 2115975.31483 37.7901584138266 -122.438103221909 (37.7901584138266, -122.438103221909) 13 6 1 29490 27
14016 249712 1 70 2975 Broadway 1 Back Yard : Yard Tree 2     21     5999372.04623 2116967.23886 37.7927511539072 -122.44611721374 (37.7927511539072, -122.44611721374) 13 9 1 29490 27
14158 99903 7 70 2001X Washington St 5 Sidewalk: Curb side : Cutout Tree 2         Permit Number 768908 6005125.9 2116783.4 37.792573279433 -122.426195525639 (37.792573279433, -122.426195525639) 13 9 1 28858 27
14184 82402 1 70 41X 17th Ave 3 Sidewalk: Curb side : Cutout Tree 2     14 3x3   5990494.67077 2114802.82802 37.7862973373572 -122.476674787546 (37.7862973373572, -122.476674787546) 11 6 1 55 33
14423 114573 1 70 3621 Washington St 1 Sidewalk: Curb side : Cutout Tree 2   10/03/2019 12:00:00 AM 3 3x3   5997465.48926 2115720.33673 37.7892184334409 -122.452623918478 (37.7892184334409, -122.452623918478) 11 6 1 54 31
14540 125028 1 70 1454 Jefferson St 1 Sidewalk: Curb side : Cutout Tree 2     8 Width 3ft   6002238.36811 2121596.51915 37.8056252134011 -122.436531126017 (37.8056252134011, -122.436531126017) 13 9 1 57 17
14952 124990 1 70 2354 Bay St 2 Sidewalk: Curb side : Cutout Tree 2     10 Width 3ft   5999518.65691 2120176.7884 37.8015720930274 -122.44584087006 (37.8015720930274, -122.44584087006) 13 9 1 57 17
15097 125078 1 70 2402 Steiner St 1 Sidewalk: Curb side : Cutout Tree 2     21 Width 5ft   6002281.85498 2116525.22121 37.7917032260602 -122.4360175223 (37.7917032260602, -122.4360175223) 13 9 1 29490 27
15359 124880 1 70 3820 Washington St 1 Sidewalk: Curb side : Cutout Tree 2     17 Width 6ft   5996409.41763 2115616.90715 37.7888738770624 -122.456270294343 (37.7888738770624, -122.456270294343) 11 6 1 54 31
15453 103382 4 70 3199X JACKSON ST 2 Sidewalk: Curb side : Cutout Tree 2           5999158 2116301 37.7909096124749 -122.446809858862 (37.7909096124749, -122.446809858862) 13 6 1 29490 31
15739 23509 1 70 2620 Van Ness Ave 1 Sidewalk: Curb side : Cutout Tree 1     30 3X3   6005816.48256 2119432.12103 37.7998850066476 -122.423994524448 (37.7998850066476, -122.423994524448) 13 9 1 28858 32
16669 66481 1 70 2290 Vallejo St 1 Sidewalk: Curb side : Cutout Tree 2   01/31/1991 12:00:00 AM 17   Permit Number 29638 6002649.70784 2117838.97461 37.7953313448215 -122.434838746712 (37.7953313448215, -122.434838746712) 13 9 1 57 17
16802 52926 1 70 171 25th Ave 1 Sidewalk: Curb side : Cutout Tree 2 FUF   5 3x3 Permit Number 48909 5988008.14773 2114828.39565 37.7862229995097 -122.485279285217 (37.7862229995097, -122.485279285217) 11 6 1 55 33
16921 125192 1 70 2809 Buchanan St 5 Sidewalk: Curb side : Cutout Tree 2     10 Width 4ft   6003488.35981 2118026.85016 37.7958947817809 -122.431950297892 (37.7958947817809, -122.431950297892) 13 9 1 57 17
17126 45658 1 70 1330 Union St 3 Sidewalk: Curb side : Cutout Tree 2     19   Permit Number 44353 6006599 2119096 37.7990062508654 -122.421262834262 (37.7990062508654, -122.421262834262) 13 9 1 28858 32
17202 132596 1 70 3437 Clay St 2 Sidewalk: Curb side : Cutout Tree 2     36 Width 5ft   5998295.07475 2115506.79516 37.7886796028307 -122.449738271914 (37.7886796028307, -122.449738271914) 13 6 1 54 31
17786 258887 1 70 1251 Franklin St 4 Sidewalk: Curb side : Cutout Tree 2       Width 4ft   6005937.37607 2114355.05187 37.785951472517 -122.423215093814 (37.785951472517, -122.423215093814) 13 9 1 28858 41
17877 101023 4 70 3024 Baker St 1 Sidewalk: Curb side : Cutout Tree 2       3x3   5999465 2119192 37.7988650643156 -122.445955676486 (37.7988650643156, -122.445955676486) 13 9 1 57 17
18286 124768 1 70 3030 Baker St 1 Sidewalk: Curb side : Cutout Tree 2     19 Width 4ft   5999457.57205 2119269.23943 37.799076718977 -122.445986937943 (37.799076718977, -122.445986937943) 13 9 1 57 17
19219 18871 1 70 2269 Sacramento St 1 Sidewalk: Curb side : Cutout Tree 1     18 3X3   6003913.28197 2115924.59754 37.7901466122144 -122.430329924961 (37.7901466122144, -122.430329924961) 13 9 1 29490 27
19351 125032 1 70 1490 Jefferson St 3 Sidewalk: Curb side : Cutout Tree 2     11 Width 3ft   6002182.39111 2121589.19488 37.8056019218535 -122.436724317478 (37.8056019218535, -122.436724317478) 13 9 1 57 17
19888 125117 1 70 3170 Jackson St 2 Sidewalk: Curb side : Cutout Tree 2     12 Width 5ft   5999039.29441 2116309.03861 37.7909249024118 -122.44722115226 (37.7909249024118, -122.44722115226) 13 6 1 29490 31
20113 124934 1 70 313 Maple St 4 Sidewalk: Curb side : Cutout Tree 2     13 Width 3ft   5996638.30422 2115205.01677 37.7877560728439 -122.455448601768 (37.7877560728439, -122.455448601768) 11 6 1 54 31
20303 101420 1 70 2200 Broderick St 1 Sidewalk: Curb side : Cutout Tree 2     10     6000374.3516 2116185.0207 37.7906605745677 -122.442593016179 (37.7906605745677, -122.442593016179) 13 6 1 29490 27
20469 114842 4 70 2670 LEAVENWORTH ST 2 Sidewalk: Curb side : Cutout Tree 2       3x3   6007398 2121652 37.8060693936166 -122.418679378695 (37.8060693936166, -122.418679378695) 5 1 1 308 23