trees

1,914 rows where qSpecies_id = 45 sorted by PlantDate

✎ View and edit SQL

This data as json, CSV (advanced)

rowid TreeID qLegalStatus_id qSpecies_id qAddress SiteOrder qSiteInfo PlantType qCaretaker_id qCareAssistant PlantDate ▼ DBH PlotSize PermitNotes XCoord YCoord Latitude Longitude Location Fire Prevention Districts Police Districts Supervisor Districts Zip Codes Neighborhoods (old)
2464 190663 DPW Maintained 1 :: 45 1360 Fairfax Ave 5 : Tree Private 2     2 Width 3ft   6016747.40621 2097393.16894 37.7399818904553 -122.384633036796 (37.7399818904553, -122.384633036796) 10 3 8 58 1
2548 104858 DPW Maintained 1 :: 45 4205 24th St   Sidewalk: Property side : Cutout Landscaping Private 2           6001816 2101720.7 37.7510272133613 -122.436569249202 (37.7510272133613, -122.436569249202) 2 4 5 28862 22
2779 117319 Permitted Site 7 :: 45 1935 09th Ave 1 Sidewalk: Curb side : Cutout Tree Private 2           5993426.4 2102307.1 37.7521569948021 -122.465623688401 (37.7521569948021, -122.465623688401) 1 8 4 29491 12
2785 261137 DPW Maintained 1 :: 45 2454 47th Ave 1 Sidewalk: Curb side : Cutout Tree Private 2           5981796.50413 2098381.86438 37.7407017304597 -122.505550019662 (37.7407017304597, -122.505550019662) 1 8 3 29491 35
2802 181592 DPW Maintained 1 :: 45 1659 37th Ave 2 Sidewalk: Curb side : Cutout Tree Private 2     0 Width 0ft   5984670.7327 2103886.5941 37.7559849420617 -122.496018183642 (37.7559849420617, -122.496018183642) 1 8 3 56 35
2909 182639 DPW Maintained 1 :: 45 1850 36th Ave 1 Sidewalk: Curb side : Yard Tree Private 2     0 Width 0ft   5985068.7348 2102608.8093 37.752499800535 -122.494547587265 (37.752499800535, -122.494547587265) 1 8 3 56 35
2959 141420 DPW Maintained 1 :: 45 550 IVY ST 1 Sidewalk: Curb side : Cutout Tree Private 2     0 Width 0ft   6004578.5445 2111046.5078 37.7767902513835 -122.427680466931 (37.7767902513835, -122.427680466931) 7 9 11 28852 10
3262 143122 DPW Maintained 1 :: 45 1965 LOMBARD ST 1 Sidewalk: Curb side : Cutout Tree Private 2     0 Width 0ft   6003008.0203 2119542.9474 37.8000303489096 -122.433720773421 (37.8000303489096, -122.433720773421) 13 9 1 57 17
3549 141425 DPW Maintained 1 :: 45 301 LINDEN ST 1 Sidewalk: Curb side : Cutout Tree Private 2     0 Width 0ft   6005907.6073 2110863.9151 37.7763639855674 -122.423069853164 (37.7763639855674, -122.423069853164) 7 9 11 28852 10
4568 253833 DPW Maintained 1 :: 45 607 Eddy St 2 Sidewalk: Curb side : Cutout Tree Private 2 DPW     3x3                      
4838 142080 DPW Maintained 1 :: 45 560 LYON ST 1 Sidewalk: Curb side : Cutout Tree Private 2     0 Width 0ft   6000142.3776 2110889.4402 37.7761070510385 -122.44301516716 (37.7761070510385, -122.44301516716) 15 5 11 29492 16
4931 185584 DPW Maintained 1 :: 45 2066 30th Ave 1 Sidewalk: Curb side : Yard Tree Private 2     0 Width 0ft   5986983.4623 2101205.4528 37.7487584406856 -122.487823126868 (37.7487584406856, -122.487823126868) 1 8 3 29491 35
5154 182781 DPW Maintained 1 :: 45 1742 35th Ave 1 Sidewalk: Curb side : Yard Tree Private 2     0 Width 0ft   5985353.0616 2103349.1064 37.7545490898351 -122.493618895477 (37.7545490898351, -122.493618895477) 1 8 3 56 35
5156 182427 DPW Maintained 1 :: 45 1526 35th Ave 1 Sidewalk: Curb side : Yard Tree Private 2     0 Width 0ft   5985304.2975 2104805.6353 37.7585454628823 -122.493894864934 (37.7585454628823, -122.493894864934) 1 8 3 56 35
5360 181929 DPW Maintained 1 :: 45 2427 35th Ave 1 Sidewalk: Curb side : Yard Tree Private 2     0 Width 0ft   5985466.1527 2098683.3165 37.7417447146597 -122.492884150676 (37.7417447146597, -122.492884150676) 1 8 3 29491 35
5583 244247 Undocumented 4 :: 45 200 Octavia St 1 Sidewalk: Curb side : Cutout Tree Private 2     0 Width 0ft   6005673.0642 2110022.689 37.7740409443959 -122.423821374378 (37.7740409443959, -122.423821374378) 7 9 11 28852 10
5762 182417 DPW Maintained 1 :: 45 1544 36th Ave 2 Sidewalk: Curb side : Yard Tree Private 2     0 Width 0ft   5984999.4264 2104687.6498 37.758203665255 -122.494940531373 (37.758203665255, -122.494940531373) 1 8 3 56 35
5914 254656 Private 9 :: 45 640 Larch St 1 Sidewalk: Curb side : Cutout Tree Private 2       3x3   6004524 2112776 37.781535924842 -122.427992425483 (37.781535924842, -122.427992425483) 7 9 11 29490 41
5962 190650 DPW Maintained 1 :: 45 501 Wisconsin St 1 Sidewalk: Curb side : Cutout Tree Private 2     6 Width 3ft   6012697.31498 2105105.25182 37.7609327945277 -122.399177878376 (37.7609327945277, -122.399177878376) 10 3 8 28856 29
6291 182272 DPW Maintained 1 :: 45 1494 35th Ave 1 Sidewalk: Curb side : Yard Tree Private 2     0 Width 0ft   5985296.227 2105059.6558 37.7592424604916 -122.493941496366 (37.7592424604916, -122.493941496366) 1 8 3 56 35
6366 117001 DPW Maintained 1 :: 45 1X Bernal Heights Blvd 1 Front Yard : Yard Tree DPW 1                              
6450 184722 DPW Maintained 1 :: 45 1643 37th Ave 1 Sidewalk: Curb side : Yard Tree Private 2     0 Width 0ft   5984666.6891 2104002.5093 37.7563029761962 -122.496040718779 (37.7563029761962, -122.496040718779) 1 8 3 56 35
6678 183829 DPW Maintained 1 :: 45 2214 28th Ave 2 Sidewalk: Curb side : Cutout Tree Private 2     0 Width 0ft   5987634.5167 2100198.0441 37.7460303199634 -122.485497894293 (37.7460303199634, -122.485497894293) 1 8 3 29491 35
6870 182679 DPW Maintained 1 :: 45 2631 Moraga St 1 Sidewalk: Curb side : Yard Tree Private 2     0 Width 0ft   5986083.8267 2103639.2241 37.7553883964845 -122.491113101083 (37.7553883964845, -122.491113101083) 1 8 3 56 35
6909 184218 DPW Maintained 1 :: 45 3441 Kirkham St 2 Sidewalk: Curb side : Cutout Tree Private 2     0 Width 0ft   5984096.8823 2104933.319 37.758825328706 -122.49808001485 (37.758825328706, -122.49808001485) 1 8 3 56 35
7142 183990 DPW Maintained 1 :: 45 1678 35th Ave 2 Sidewalk: Curb side : Yard Tree Private 2     0 Width 0ft   5985337.0123 2103802.0601 37.7557918369667 -122.493707772777 (37.7557918369667, -122.493707772777) 1 8 3 56 35
7154 184667 DPW Maintained 1 :: 45 1675 37th Ave 1 Sidewalk: Curb side : Yard Tree Private 2     0 Width 0ft   5984673.0914 2103809.4296 37.7557732078979 -122.496004334161 (37.7557732078979, -122.496004334161) 1 8 3 56 35
7226 139441 DPW Maintained 1 :: 45 501 GROVE ST 2 Sidewalk: Curb side : Cutout Tree Private 2     0 Width 0ft   6005361.8674 2111299.9206 37.7775303390293 -122.424988750303 (37.7775303390293, -122.424988750303) 7 9 11 28852 10
7264 182773 DPW Maintained 1 :: 45 1 33rd Ave 1 Sidewalk: Curb side : Yard Tree Private 2     0 Width 0ft   5985975.4571 2103368.6441 37.754639125693 -122.491467955558 (37.754639125693, -122.491467955558) 1 8 3 56 35
7483 116947 Undocumented 4 :: 45 3676 23RD ST 7 Sidewalk: Curb side : Cutout Tree Private 2       3x3   6005238 2102584 37.7535915013127 -122.424797029407 (37.7535915013127, -122.424797029407) 2 4 5 28859 19
7525 183813 DPW Maintained 1 :: 45 2101 Rivera St 1 Sidewalk: Curb side : Yard Tree Private 2     0 Width 0ft   5986596.0486 2100254.1602 37.7461238416302 -122.489092856091 (37.7461238416302, -122.489092856091) 1 8 3 29491 35
7704 140222 DPW Maintained 1 :: 45 610 FILLMORE ST 1 Sidewalk: Curb side : Cutout Tree Private 2     0 Width 0ft   6003683.3616 2110416.1551 37.7750087812949 -122.430732178175 (37.7750087812949, -122.430732178175) 7 9 11 29492 10
7740 142745 DPW Maintained 1 :: 45 700x COLUMBUS AVE 8 Median : Cutout Tree DPW 1     0 Width 0ft   6009127.5357 2120116.4029 37.8019502507169 -122.412585395041 (37.8019502507169, -122.412585395041) 3 1 10 308 4
7759 181568 DPW Maintained 1 :: 45 1349 37th Ave 1 Sidewalk: Curb side : Cutout Tree Private 2     0 Width 0ft   5984597.8609 2105995.9427 37.7617723563961 -122.496425834494 (37.7617723563961, -122.496425834494) 1 8 3 56 35
7819 184095 DPW Maintained 1 :: 45 1611 33rd Ave 1 Sidewalk: Curb side : Yard Tree Private 2     0 Width 0ft   5985901.3945 2104240.0581 37.757027460882 -122.491788227731 (37.757027460882, -122.491788227731) 1 8 3 56 35
7832 183984 DPW Maintained 1 :: 45 2420 Moraga St 1 Sidewalk: Curb side : Yard Tree Private 2     0 Width 0ft   5986737.6029 2103717.4696 37.755641413652 -122.488857926532 (37.755641413652, -122.488857926532) 1 8 3 56 35
7884 182867 DPW Maintained 1 :: 45 1841 28th Ave 1 Sidewalk: Curb side : Yard Tree Private 2     0 Width 0ft   5987504.2554 2102741.89 37.7530074484719 -122.486135022058 (37.7530074484719, -122.486135022058) 1 8 3 56 35
8110 200249 DPW Maintained 1 :: 45 1067 Ingerson Ave 1 unknown : Yard Tree Private 2     0 Width 0ft   6013803.2037 2090093.549 37.7197753570889 -122.394301997885 (37.7197753570889, -122.394301997885) 10 3 8 58 1
8301 114726 Significant Tree 6 :: 45 520 Townsend St 2 Front Yard : Yard Tree Private 2           6012508.1 2109575.3 37.7731959986981 -122.400146236912 (37.7731959986981, -122.400146236912) 14 2 9 28853 34
8458 259610 DPW Maintained 1 :: 45 1107 Visitacion Ave 1 Sidewalk: Curb side : Cutout Tree DPW 1 FUF         6009254.2033 2087326.13058 37.7119226839796 -122.409831104788 (37.7119226839796, -122.409831104788) 9 7 8 309 39
8481 70091 DPW Maintained 1 :: 45 752 24th Ave 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF   6 3x3   5988512.5089 2110855.81451 37.7753447787774 -122.483243045223 (37.7753447787774, -122.483243045223) 11 6 2 55 26
8635 182608 DPW Maintained 1 :: 45 1839 35th Ave 1 Sidewalk: Curb side : Yard Tree Private 2     0 Width 0ft   5985333.4224 2102688.337 37.7527336497539 -122.493638125681 (37.7527336497539, -122.493638125681) 1 8 3 56 35
8688 183776 DPW Maintained 1 :: 45 2042 Santiago St 2 Sidewalk: Curb side : Yard Tree Private 2     0 Width 0ft   5986449.4639 2099625.7878 37.7443899427786 -122.489553521138 (37.7443899427786, -122.489553521138) 1 8 3 29491 35
8891 182186 DPW Maintained 1 :: 45 1638 25th Ave 2 Sidewalk: Curb side : Yard Tree Private 2     0 Width 0ft   5988430.2421 2104156.5357 37.75694560898 -122.483036497181 (37.75694560898, -122.483036497181) 1 8 3 56 35
8915 253260 DPW Maintained 1 :: 45 734 09th Ave 1 Sidewalk: Curb side : Cutout Tree Private 2       3x3   5993234 2110465 37.7745453462497 -122.466882031228 (37.7745453462497, -122.466882031228) 11 6 2 54 11
9196 182652 DPW Maintained 1 :: 45 1871 27th Ave 1 Sidewalk: Curb side : Yard Tree Private 2     0 Width 0ft   5987819.8145 2102562.9873 37.7525346157683 -122.485030647048 (37.7525346157683, -122.485030647048) 1 8 3 56 35
9359 114615 Undocumented 4 :: 45 2400X Post St 2 Sidewalk: Curb side : Cutout Tree Private 2           6000387.7 2114050.6 37.7848007706075 -122.442393531976 (37.7848007706075, -122.442393531976) 15 6 11 29490 13
9415 200180 DPW Maintained 1 :: 45 1031 Hollister Ave 1 unknown : Yard Tree Private 2     0 Width 0ft   6014690.5634 2089785.0188 37.7189774793874 -122.391213128817 (37.7189774793874, -122.391213128817) 10 3 8 58 1
9699 139024 DPW Maintained 1 :: 45 2511 SUTTER ST 2 Sidewalk: Curb side : Cutout Tree Private 2     0 Width 0ft   6000470.0552 2114083.3913 37.7848955007169 -122.442110965396 (37.7848955007169, -122.442110965396) 15 6 11 29490 13
9802 245988 Undocumented 4 :: 45 1250 Waller St 1 Sidewalk: Curb side : Cutout Tree Private 2     0 Width 0ft   5999884.6674 2108495.9392 37.7695204065663 -122.443734660449 (37.7695204065663, -122.443734660449) 15 5 11 29492 9
9942 200177 DPW Maintained 1 :: 45 1041 Hollister Ave 1 unknown : Yard Tree Private 2     0 Width 0ft   6014650.3204 2089811.8475 37.7190489123065 -122.39135410876 (37.7190489123065, -122.39135410876) 10 3 8 58 1
10097 182694 DPW Maintained 1 :: 45 1715 33rd Ave 1 Sidewalk: Curb side : Yard Tree Private 2     0 Width 0ft   5985923.1814 2103540.9984 37.7551093083613 -122.491661423134 (37.7551093083613, -122.491661423134) 1 8 3 56 35
10197 251293 DPW Maintained 1 :: 45 3789 Market St 1 Sidewalk: Property side : Cutout Landscaping Private 2       3x3   6000208 2102740 37.753734455764 -122.442203020617 (37.753734455764, -122.442203020617) 2 4 5 63 38
10228 142720 Undocumented 4 :: 45 1170 COLUMBUS AVE 3 Sidewalk: Curb side : Cutout Tree Private 2       Width 0ft   6007999.4825 2121188.7351 37.8048312311886 -122.416565007078 (37.8048312311886, -122.416565007078) 5 1 10 308 23
10269 182332 DPW Maintained 1 :: 45 1494 34th Ave 1 Sidewalk: Curb side : Yard Tree Private 2     0 Width 0ft   5985606.7756 2105058.9207 37.7592586073358 -122.492867430666 (37.7592586073358, -122.492867430666) 1 8 3 56 35
10564 114630 Undocumented 4 :: 45 2400X Post St 16 Sidewalk: Curb side : Cutout Tree Private 2           6000387.7 2114050.6 37.7848007706075 -122.442393531976 (37.7848007706075, -122.442393531976) 15 6 11 29490 13
10776 219180 DPW Maintained 1 :: 45 1785 07th Ave 2 Sidewalk: Curb side : Cutout Tree Private 2     9 Width 4ft   5994012.85069 2103371.98784 37.7551147123942 -122.463672948647 (37.7551147123942, -122.463672948647) 1 5 4 56 12
10819 182695 DPW Maintained 1 :: 45 1710 36th Ave 1 Sidewalk: Curb side : Yard Tree Private 2     0 Width 0ft   5985039.9277 2103526.5304 37.7550179237557 -122.49471485915 (37.7550179237557, -122.49471485915) 1 8 3 56 35
11222 182601 DPW Maintained 1 :: 45 1963 33rd Ave 1 Sidewalk: Curb side : Yard Tree Private 2     0 Width 0ft   5985980.7032 2101872.2576 37.750530763347 -122.491339684637 (37.750530763347, -122.491339684637) 1 8 3 29491 35
11414 173708 DPW Maintained 1 :: 45 126 Gold Mine Dr 1 Sidewalk: Curb side : Cutout Tree DPW 1       3x3   6001214 2098705 37.7427125900371 -122.438434982469 (37.7427125900371, -122.438434982469) 2 7 5 63 7
11756 108765 Undocumented 4 :: 45 500X Lathrop Ave 4 Sidewalk: Curb side : Cutout Tree Private 2 FUF         6012750.2 2086624.6 37.7101917236901 -122.397698699654 (37.7101917236901, -122.397698699654) 10 3 8 309 1
11763 108805 Undocumented 4 :: 45 401-499 University St 6 Sidewalk: Curb side : Cutout Tree Private 2           6008323.15237 2092121.01007 37.7250361958168 -122.413387969207 (37.7250361958168, -122.413387969207) 9 3 7 309 28
11776 108812 Undocumented 4 :: 45 301-399 University St 8 Sidewalk: Curb side : Cutout Tree Private 2           6008160.40727 2092653.74948 37.7264898456848 -122.413988233103 (37.7264898456848, -122.413988233103) 9 3 7 309 28
12235 184717 DPW Maintained 1 :: 45 1630 39th Ave 1 Sidewalk: Curb side : Yard Tree Private 2     0 Width 0ft   5984088.6295 2104052.5482 37.7564064943727 -122.498043512944 (37.7564064943727, -122.498043512944) 1 8 3 56 35
12298 182617 DPW Maintained 1 :: 45 1870 33rd Ave 1 Sidewalk: Curb side : Yard Tree Private 2     0 Width 0ft   5986004.9641 2102510.2071 37.7522838165719 -122.491302737104 (37.7522838165719, -122.491302737104) 1 8 3 56 35
12451 200191 DPW Maintained 1 :: 45 981 Ingerson Ave 1 unknown : Yard Tree Private 2     0 Width 0ft   6014255.2675 2089757.5194 37.7188778046353 -122.392715865878 (37.7188778046353, -122.392715865878) 10 3 8 58 1
12463 184537 DPW Maintained 1 :: 45 1920 Lower Great Hwy 1 Sidewalk: Curb side : Yard Tree Private 2     0 Width 0ft   5981149.921 2101972.2688 37.7505219025706 -122.508052026926 (37.7505219025706, -122.508052026926) 1 8 3 29491 35
12753 253419 Planning Code 138.1 required 2 :: 45 3499 Jackson St 1 Sidewalk: Curb side : Cutout Tree Private 2       3x3   5997570 2115996 37.7899813188913 -122.452282225129 (37.7899813188913, -122.452282225129) 11 6 1 54 31
12771 184293 DPW Maintained 1 :: 45 1547 41st Ave 1 Sidewalk: Curb side : Yard Tree Private 2     0 Width 0ft   5983406.1489 2104611.5311 37.7579012669465 -122.500445060495 (37.7579012669465, -122.500445060495) 1 8 3 56 35
12777 137758 DPW Maintained 1 :: 45 101 Saint Joseph's Ave 19 Sidewalk: Curb side : Cutout Tree Private 2     0 Width 0ft   6000707.9938 2112291.934 37.7799901751967 -122.441159201538 (37.7799901751967, -122.441159201538) 15 5 1 29490 16
12815 261606 DPW Maintained 1 :: 45 108 Shields St 1 Sidewalk: Curb side : Cutout Tree Private 2           5993739.19456 2089854.88419 37.7179843347129 -122.463638343115 (37.7179843347129, -122.463638343115) 9 8 6 64 24
12843 181862 DPW Maintained 1 :: 45 2334 27th Ave 1 Sidewalk: Curb side : Yard Tree Private 2     0 Width 0ft   5987972.6737 2099405.6778 37.7438743880052 -122.484270504939 (37.7438743880052, -122.484270504939) 1 8 3 29491 35
12997 258944 DPW Maintained 1 :: 45 190 Freelon St 1 Sidewalk: Curb side : Yard Landscaping DPW 1       Width 2ft   6013228 2111376 37.7781804260272 -122.397782321929 (37.7781804260272, -122.397782321929) 6 2 9 28856 34
13184 185817 DPW Maintained 1 :: 45 2537 Pacheco St 1 Sidewalk: Curb side : Yard Tree Private 2     0 Width 0ft   5987057.2145 2101634.1584 37.7499398526357 -122.487599584974 (37.7499398526357, -122.487599584974) 1 8 3 29491 35
13222 181595 DPW Maintained 1 :: 45 1683 37th Ave 1 Sidewalk: Curb side : Yard Tree Private 2     0 Width 0ft   5984673.7654 2103756.5264 37.7556279898559 -122.495998100633 (37.7556279898559, -122.495998100633) 1 8 3 56 35
13385 244231 DPW Maintained 1 :: 45 576 Haight St 1 Sidewalk: Curb side : Cutout Tree Private 2     4 Width 0ft   6003405.9505 2109334.219 37.7720223304628 -122.431614542708 (37.7720223304628, -122.431614542708) 15 9 11 29492 10
13524 182760 DPW Maintained 1 :: 45 1759 33rd Ave 1 Sidewalk: Curb side : Yard Tree Private 2     0 Width 0ft   5985932.2165 2103268.4413 37.7543614693016 -122.491610115485 (37.7543614693016, -122.491610115485) 1 8 3 56 35
13679 181829 DPW Maintained 1 :: 45 2305 34th Ave 1 Sidewalk: Curb side : Yard Tree Private 2     3 4x6   5985752.5421 2099501.8742 37.7440089976812 -122.491954176178 (37.7440089976812, -122.491954176178) 1 8 3 29491 35
13772 184591 DPW Maintained 1 :: 45 1751 41st Ave 1 Sidewalk: Curb side : Yard Tree Private 2     0 Width 0ft   5983451.02 2103228.4905 37.7541064586728 -122.500187636281 (37.7541064586728, -122.500187636281) 1 8 3 56 35
14295 185818 DPW Maintained 1 :: 45 2050 22nd Ave 1 Sidewalk: Curb side : Yard Tree Private 2     0 Width 0ft   5989456.1302 2101394.5128 37.7494214709702 -122.479286579382 (37.7494214709702, -122.479286579382) 1 8 3 29491 35
14351 109754 Permitted Site 7 :: 45 601 Steiner St 1 Sidewalk: Property side : Cutout Landscaping Private 2       1x12   6003025.4 2110381.6 37.7748766027312 -122.433005738531 (37.7748766027312, -122.433005738531) 15 5 11 29492 10
14473 246016 DPW Maintained 1 :: 45 1605 Haight St 1 Sidewalk: Curb side : Pot Tree Private 2     0 Width 0ft   5998345.69 2108581.6399 37.7696678206354 -122.449064074288 (37.7696678206354, -122.449064074288) 15 5 11 29492 9
14488 182431 DPW Maintained 1 :: 45 1550 34th Ave 1 Sidewalk: Curb side : Yard Tree Private 2     0 Width 0ft   5985622.7002 2104651.6438 37.7581412688876 -122.492782358773 (37.7581412688876, -122.492782358773) 1 8 3 56 35
14593 184704 DPW Maintained 1 :: 45 1615 37th Ave 1 Sidewalk: Curb side : Yard Tree Private 2     0 Width 0ft   5984659.276 2104181.7734 37.756794751431 -122.496079580355 (37.756794751431, -122.496079580355) 1 8 3 56 35
14703 183463 DPW Maintained 1 :: 45 2530 26th Ave 1 Sidewalk: Curb side : Yard Tree Private 2     0 Width 0ft   5988329.4378 2098069.925 37.7402275284168 -122.482939034698 (37.7402275284168, -122.482939034698) 1 8 3 29491 35
14882 185772 DPW Maintained 1 :: 45 1907 20th Ave 1 Sidewalk: Curb side : Yard Tree Private 2     0 Width 0ft   5989998.872 2102362.4304 37.7521106251699 -122.477480519353 (37.7521106251699, -122.477480519353) 1 8 3 29491 35
14972 183006 DPW Maintained 1 :: 45 2438 21st Ave 1 Sidewalk: Curb side : Yard Tree Private 2     0 Width 0ft   5989859.0631 2098748.8104 37.7421804576164 -122.477699875038 (37.7421804576164, -122.477699875038) 1 8 3 29491 35
15236 185780 DPW Maintained 1 :: 45 1905 31st Ave 1 Sidewalk: Curb side : Yard Tree Private 2     0 Width 0ft   5986589.1657 2102275.5585 37.7516736541674 -122.489265251741 (37.7516736541674, -122.489265251741) 1 8 3 29491 35
15261 183802 DPW Maintained 1 :: 45 1721 Rivera St 1 Sidewalk: Curb side : Cutout Tree Private 2     0 Width 0ft   5987778.7543 2100296.1939 37.746308215746 -122.485006345677 (37.746308215746, -122.485006345677) 1 8 3 29491 35
15437 187452 DPW Maintained 1 :: 45 5098 Mission St 4 Sidewalk: Curb side : Yard Tree Private 2     0 Width 0ft   6000296.2838 2089278.8073 37.7167782039769 -122.440932105905 (37.7167782039769, -122.440932105905) 9 7 6 28861 25
15533 182259 DPW Maintained 1 :: 45 1458 34th Ave 1 Sidewalk: Curb side : Yard Tree Private 2     0 Width 0ft   5985599.4253 2105281.2662 37.7598686766173 -122.492909228949 (37.7598686766173, -122.492909228949) 1 8 3 56 35
15678 182539 DPW Maintained 1 :: 45 1583 33rd Ave 2 Sidewalk: Curb side : Cutout Tree Private 2     0 Width 0ft   5985893.7944 2104453.9852 37.757614401574 -122.491830260053 (37.757614401574, -122.491830260053) 1 8 3 56 35
15784 114629 Undocumented 4 :: 45 2400X Post St 15 Sidewalk: Curb side : Cutout Tree Private 2           6000387.7 2114050.6 37.7848007706075 -122.442393531976 (37.7848007706075, -122.442393531976) 15 6 11 29490 13
15900 108806 Undocumented 4 :: 45 401-499 University St 8 Sidewalk: Curb side : Cutout Tree Private 2           6008323.15237 2092121.01007 37.7250361958168 -122.413387969207 (37.7250361958168, -122.413387969207) 9 3 7 309 28
15911 105081 Significant Tree 6 :: 45 344 Fulton St 1 Front Yard : Yard Tree Private 2           6006101.8 2111789.5 37.7789163735632 -122.422463868572 (37.7789163735632, -122.422463868572) 7 9 11 28852 10
16060 181864 DPW Maintained 1 :: 45 2335 26th Ave 1 Sidewalk: Curb side : Yard Tree Private 2     0 Width 0ft   5988236.9812 2099405.6778 37.7438897740704 -122.483356602194 (37.7438897740704, -122.483356602194) 1 8 3 29491 35
16374 200211 DPW Maintained 1 :: 45 974 Jamestown Ave 1 Sidewalk: Curb side : Yard Tree Private 2     0 Width 0ft   6014078.3317 2089599.897 37.7184351760665 -122.39331644356 (37.7184351760665, -122.39331644356) 10 3 8 58 1
16538 142301 DPW Maintained 1 :: 45 1706 GROVE ST 2 Sidewalk: Curb side : Cutout Tree Private 2     0 Width 0ft   5999608.3299 2110545.035 37.7751309388293 -122.444837812331 (37.7751309388293, -122.444837812331) 15 5 11 29492 16
16705 186840 DPW Maintained 1 :: 45 1201 36th Ave 2 Sidewalk: Curb side : Yard Tree Private 2     0 Width 0ft   5984884.6409 2106758.5555 37.763883073514 -122.495490239842 (37.763883073514, -122.495490239842) 1 8 3 56 35
17108 105086 Significant Tree 6 :: 45 344 Fulton St 6 Front Yard : Yard Tree Private 2           6006101.8 2111789.5 37.7789163735632 -122.422463868572 (37.7789163735632, -122.422463868572) 7 9 11 28852 10

Next page

Advanced export

JSON shape: default, array, newline-delimited, object

CSV options: 

CREATE TABLE "trees" (
   [rowid] INTEGER PRIMARY KEY,
   [TreeID] TEXT,
   [qLegalStatus_id] INTEGER REFERENCES [qLegalStatus]([id]),
   [qSpecies_id] INTEGER,
   [qAddress] TEXT,
   [SiteOrder] TEXT,
   [qSiteInfo] TEXT,
   [PlantType] TEXT,
   [qCaretaker_id] INTEGER REFERENCES [qCaretaker]([id]),
   [qCareAssistant] TEXT,
   [PlantDate] TEXT,
   [DBH] TEXT,
   [PlotSize] TEXT,
   [PermitNotes] TEXT,
   [XCoord] TEXT,
   [YCoord] TEXT,
   [Latitude] TEXT,
   [Longitude] TEXT,
   [Location] TEXT,
   [Fire Prevention Districts] TEXT,
   [Police Districts] TEXT,
   [Supervisor Districts] TEXT,
   [Zip Codes] TEXT,
   [Neighborhoods (old)] TEXT,
   FOREIGN KEY(qSpecies_id) REFERENCES qSpecies(id)
);