trees

484 rows where qSpecies_id = 56 sorted by qCaretaker_id

✎ 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)
5310 209020 DPW Maintained 1 Eucalyptus globulus :: Blue Gum 56 33 Martha Ave 4 : Yard Tree Private 2     12     6000767.68455 2095534.49854 37.7339817396554 -122.439750952547 (37.7339817396554, -122.439750952547) 9 7 5 63 40
6347 224265 DPW Maintained 1 Eucalyptus globulus :: Blue Gum 56 58 Poppy Ln 1 Back Yard : Yard Tree Private 2     38     6002671.84671 2096513.90824 37.7367791753169 -122.433237644116 (37.7367791753169, -122.433237644116) 2 7 5 63 7
7245 251144 Significant Tree 6 Eucalyptus globulus :: Blue Gum 56 200X Clarendon Ave 3 Sidewalk: Property side : Yard Tree Private 2       3x3   5996559 2104265 37.7577130831875 -122.454932197022 (37.7577130831875, -122.454932197022) 15 5 4 63 12
7655 224252 DPW Maintained 1 Eucalyptus globulus :: Blue Gum 56 401x Powhattan Ave 4 Sidewalk: Property side : Yard Tree Private 2     35 Width 3ft   6008209.41115 2098117.01266 37.741493532991 -122.414205186423 (37.741493532991, -122.414205186423) 2 7 7 28859 2
8037 257932 Undocumented 4 Eucalyptus globulus :: Blue Gum 56 1039 Hudson Ave 3 Sidewalk: Curb side : Cutout Tree Private 2       3x3   6018789 2095103 37.7338062313868 -122.377415095373 (37.7338062313868, -122.377415095373) 10 3 8 58 1
8712 207757 DPW Maintained 1 Eucalyptus globulus :: Blue Gum 56 95 Kirkham St 8 Sidewalk: Property side : Yard Tree Private 2     24     5994806.26925 2105291.62903 37.7604312408178 -122.461068228734 (37.7604312408178, -122.461068228734) 15 5 4 56 12
9638 254322 Undocumented 4 Eucalyptus globulus :: Blue Gum 56 220 Junipero Serra Blvd 3 Median : Cutout Tree Private 2       10x10   5991369 2094955 37.731851128725 -122.472202551974 (37.731851128725, -122.472202551974) 1 8 4 64 40
10388 251145 Significant Tree 6 Eucalyptus globulus :: Blue Gum 56 200X Clarendon Ave 2 Sidewalk: Property side : Yard Tree Private 2       3x3   5996559 2104265 37.7577130831875 -122.454932197022 (37.7577130831875, -122.454932197022) 15 5 4 63 12
10506 208985 DPW Maintained 1 Eucalyptus globulus :: Blue Gum 56 372 Santa Clara Ave 1 Sidewalk: Curb side : Yard Tree Private 2     59 Width 3ft   5993088 2095554 37.7335951664771 -122.466303177465 (37.7335951664771, -122.466303177465) 9 8 4 59 40
10615 254314 DPW Maintained 1 Eucalyptus globulus :: Blue Gum 56 190X Junipero Serra Blvd 6 Median : Yard Tree Private 2       10x10   5991377 2095081 37.732197556005 -122.472184075725 (37.732197556005, -122.472184075725) 1 8 4 64 40
11269 247818 DPW Maintained 1 Eucalyptus globulus :: Blue Gum 56 1158x Jarboe Ave 1 Unaccepted Street : Yard Tree Private 2     46     6009634.53348 2096844.36766 37.7380790724954 -122.409187798594 (37.7380790724954, -122.409187798594) 10 7 7 28859 2
11816 209009 DPW Maintained 1 Eucalyptus globulus :: Blue Gum 56 408 Baden St 1 Front Yard : Yard Tree Private 2     9     6000785.2821 2095342.66839 37.7334560202787 -122.439676364582 (37.7334560202787, -122.439676364582) 9 7 5 63 40
12354 264690 DPW Maintained 1 Eucalyptus globulus :: Blue Gum 56 99 Verna St 1 Unaccepted Street : Yard Tree Private 2       10x10   5998312 2096103 37.7354026257891 -122.448281895759 (37.7354026257891, -122.448281895759) 9 7 4 59 40
13030 208963 DPW Maintained 1 Eucalyptus globulus :: Blue Gum 56 85 Yerba Buena Ave 2 Sidewalk: Curb side : Yard Tree Private 2     30 Width 6ft   5993873 2096938 37.737440549971 -122.463689641388 (37.737440549971, -122.463689641388) 1 8 4 59 40
13191 264743 DPW Maintained 1 Eucalyptus globulus :: Blue Gum 56 270X Kensington Way 2 Median : Yard Tree Private 2       20x20   5994424 2098888 37.7428264992104 -122.461925951337 (37.7428264992104, -122.461925951337) 1 8 4 59 40
16272 207772 DPW Maintained 1 Eucalyptus globulus :: Blue Gum 56 60 Santa Clara Ave 1 Sidewalk: Curb side : Yard Tree Private 2     25 Width 10ft   5993256.95856 2097201.9739 37.7381298392237 -122.46583874187 (37.7381298392237, -122.46583874187) 1 8 4 59 40
16282 65198 DPW Maintained 1 Eucalyptus globulus :: Blue Gum 56 371 Madrid St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 07/24/1989 12:00:00 AM 34   Permit Number 27183 6003158.74485 2091706.48731 37.7236066919673 -122.431211180179 (37.7236066919673, -122.431211180179) 9 7 6 28861 5
16383 7808 DPW Maintained 1 Eucalyptus globulus :: Blue Gum 56 700X Franklin St 1 Sidewalk: Curb side : Cutout Tree Private 2     18 4X4   6006239.03041 2112534.82936 37.7809706070447 -122.422042095466 (37.7809706070447, -122.422042095466) 7 9 11 28852 41
17188 260389 Significant Tree 6 Eucalyptus globulus :: Blue Gum 56 101 Santa Clara Ave 1 Sidewalk: Curb side : Yard Tree Private 2       10x6   5993303.46118 2096918.61416 37.7373544866644 -122.465657379584 (37.7373544866644, -122.465657379584) 1 8 4 59 40
17462 261945 DPW Maintained 1 Eucalyptus globulus :: Blue Gum 56 1 Verna St 10 Unaccepted Street : Yard Tree Private 2       Width 3ft   5998303 2096292 37.7359210601709 -122.448326617787 (37.7359210601709, -122.448326617787) 9 7 4 59 40
17551 261946 DPW Maintained 1 Eucalyptus globulus :: Blue Gum 56 1 Verna St 11 Unaccepted Street : Yard Tree Private 2       Width 3ft   5998303 2096292 37.7359210601709 -122.448326617787 (37.7359210601709, -122.448326617787) 9 7 4 59 40
17952 176334 DPW Maintained 1 Eucalyptus globulus :: Blue Gum 56 287 Hester Ave 7 Side Yard : Yard Tree Private 2     34     6012223.87562 2087782.54699 37.713341893097 -122.399599040764 (37.713341893097, -122.399599040764) 10 3 8 309 1
18334 224251 DPW Maintained 1 Eucalyptus globulus :: Blue Gum 56 401X Powhattan Ave 3 Sidewalk: Property side : Yard Tree Private 2     21 Width 3ft   6008204.54136 2098121.72815 37.741506207147 -122.414222358085 (37.741506207147, -122.414222358085) 2 7 7 28859 2
18898 208916 DPW Maintained 1 Eucalyptus globulus :: Blue Gum 56 55X Saint Francis Blvd 1 Sidewalk: Curb side : Yard Tree Private 2     40 Width 10ft Permit Number 782933 5992083 2096107 37.7350555268004 -122.469817969126 (37.7350555268004, -122.469817969126) 1 8 4 59 40
19448 254323 Undocumented 4 Eucalyptus globulus :: Blue Gum 56 220 Junipero Serra Blvd 4 Median : Cutout Tree Private 2       10x10   5991369 2094955 37.731851128725 -122.472202551974 (37.731851128725, -122.472202551974) 1 8 4 64 40
20018 256139 Undocumented 4 Eucalyptus globulus :: Blue Gum 56 888 Moultrie St 1 Unaccepted Street : Cutout Tree Private 2       3x3   6007515 2095179 37.7333873668614 -122.416398174089 (37.7333873668614, -122.416398174089) 2 7 7 28859 2
20382 253206 DPW Maintained 1 Eucalyptus globulus :: Blue Gum 56 2253 09th Ave 3 Sidewalk: Property side : Cutout Tree Private 2       3x3   5993186 2100608 37.7474778324271 -122.466331547971 (37.7474778324271, -122.466331547971) 1 8 4 29491 40
20776 247930 DPW Maintained 1 Eucalyptus globulus :: Blue Gum 56 1099 Esmeralda Ave 3 Side Yard : Yard Tree Private 2     18     6010384.98383 2098777.78466 37.7434298327179 -122.406729322818 (37.7434298327179, -122.406729322818) 10 7 7 28859 2
21127 176347 DPW Maintained 1 Eucalyptus globulus :: Blue Gum 56 40 Teddy Ave 2 Sidewalk: Property side : Yard Tree Private 2     29     6011214.18105 2087815.33758 37.7133755951756 -122.403091220704 (37.7133755951756, -122.403091220704) 9 7 8 309 39
21173 224240 DPW Maintained 1 Eucalyptus globulus :: Blue Gum 56 1100 San Jose Ave 42 Front Yard : Yard Tree Private 2     36     6004759.95311 2096625.2597 37.7372031562031 -122.426026066958 (37.7372031562031, -122.426026066958) 2 7 5 63 7
21658 208914 DPW Maintained 1 Eucalyptus globulus :: Blue Gum 56 45 Saint Francis Blvd 1 Sidewalk: Curb side : Yard Tree Private 2     38 Width 10ft   5991964.75621 2096031.6123 37.7348416956868 -122.470221288386 (37.7348416956868, -122.470221288386) 1 8 4 59 40
22036 254321 Undocumented 4 Eucalyptus globulus :: Blue Gum 56 220 Junipero Serra Blvd 2 Median : Cutout Tree Private 2       10x10   5991369 2094955 37.731851128725 -122.472202551974 (37.731851128725, -122.472202551974) 1 8 4 64 40
22151 224233 DPW Maintained 1 Eucalyptus globulus :: Blue Gum 56 1100 San Jose Ave 23 Front Yard : Yard Tree Private 2     22     6004845.23458 2096693.018 37.7373940247252 -122.42573603111 (37.7373940247252, -122.42573603111) 2 7 5 63 7
22782 116019 Undocumented 4 Eucalyptus globulus :: Blue Gum 56 2023 09TH AVE 1 Sidewalk: Curb side : Cutout Tree Private 2       6x6   5993447 2101700 37.7504912419676 -122.465508351594 (37.7504912419676, -122.465508351594) 1 8 4 29491 40
23508 224254 DPW Maintained 1 Eucalyptus globulus :: Blue Gum 56 190 Storrie St 4 Front Yard : Yard Tree Private 2     16 Width 3ft   6000752.12131 2105271.59361 37.7607165903087 -122.440502889194 (37.7607165903087, -122.440502889194) 15 4 5 28862 3
23607 224229 DPW Maintained 1 Eucalyptus globulus :: Blue Gum 56 1100 San Jose Ave 19 Front Yard : Yard Tree Private 2     14     6004833.29966 2096702.67223 37.7374198586269 -122.425777982686 (37.7374198586269, -122.425777982686) 2 7 5 63 7
23613 248107 DPW Maintained 1 Eucalyptus globulus :: Blue Gum 56 138 Rutledge St 1 Side Yard : Yard Tree Private 2     35     6010423.63855 2099478.50343 37.7453560168793 -122.406645033853 (37.7453560168793, -122.406645033853) 2 7 7 28859 2
23740 255978 Significant Tree 6 Eucalyptus globulus :: Blue Gum 56 36 Amber Dr 1 Front Yard : Yard Tree Private 2       3x3   5999567 2100009 37.7461992398699 -122.444223501473 (37.7461992398699, -122.444223501473) 2 7 5 63 22
23924 92900 Significant Tree 6 Eucalyptus globulus :: Blue Gum 56 208 States St 4 Back Yard : Yard Tree Private 2   08/13/2008 12:00:00 AM       6000833 2106506 37.7641105715625 -122.440311694354 (37.7641105715625, -122.440311694354) 15 5 5 28862 3
26442 176342 DPW Maintained 1 Eucalyptus globulus :: Blue Gum 56 101 Mansell St 1 Sidewalk: Curb side : Cutout Tree Private 2     18 Width 3ft   6011455.5144 2090588.63485 37.7210039820195 -122.402451970878 (37.7210039820195, -122.402451970878) 10 7 8 309 28
27522 208948 DPW Maintained 1 Eucalyptus globulus :: Blue Gum 56 340 Saint Francis Blvd 2 Sidewalk: Curb side : Yard Tree Private 2     32 Width 10ft   5992820.42769 2095999.68162 37.7348034547075 -122.467260639285 (37.7348034547075, -122.467260639285) 9 8 4 59 40
28767 176346 DPW Maintained 1 Eucalyptus globulus :: Blue Gum 56 40 Teddy Ave 1 Sidewalk: Property side : Yard Tree Private 2     18     6011228.44814 2087808.7969 37.7133584325151 -122.40304144861 (37.7133584325151, -122.40304144861) 9 7 8 309 39
29552 209015 DPW Maintained 1 Eucalyptus globulus :: Blue Gum 56 412 Baden St 3 Side Yard : Yard Tree Private 2     12     6000779.78636 2095479.1538 37.7338304646942 -122.439705146498 (37.7338304646942, -122.439705146498) 9 7 5 63 40
30561 224223 DPW Maintained 1 Eucalyptus globulus :: Blue Gum 56 1100 San Jose Ave 13 Front Yard : Yard Tree Private 2     21     6004855.41269 2096718.43509 37.7374643894683 -122.425702649156 (37.7374643894683, -122.425702649156) 2 7 5 63 7
30833 258289 Significant Tree 6 Eucalyptus globulus :: Blue Gum 56 36 Amber Dr 6 Front Yard : Yard Tree Private 2       3x3   5999567 2100009 37.7461992398699 -122.444223501473 (37.7461992398699, -122.444223501473) 2 7 5 63 22
31048 209011 DPW Maintained 1 Eucalyptus globulus :: Blue Gum 56 408 Baden St 3 Front Yard : Yard Tree Private 2     13     6000782.19416 2095354.33843 37.7334878877384 -122.439687876799 (37.7334878877384, -122.439687876799) 9 7 5 63 40
31382 208940 DPW Maintained 1 Eucalyptus globulus :: Blue Gum 56 100 Saint Francis Blvd 2 Sidewalk: Curb side : Yard Tree Private 2     37 Width 10ft   5992201.32921 2095978.53427 37.7347096311457 -122.469399518468 (37.7347096311457, -122.469399518468) 9 8 4 59 40
32721 209023 DPW Maintained 1 Eucalyptus globulus :: Blue Gum 56 34 Martha Ave 3 Front Yard : Yard Tree Private 2     20     6000780.47253 2095565.1582 37.7340666518368 -122.439708938014 (37.7340666518368, -122.439708938014) 9 7 5 63 40
33046 209043 DPW Maintained 1 Eucalyptus globulus :: Blue Gum 56 690 Mangels Ave 5 Sidewalk: Property side : Yard Tree Private 2     54 Width 10ft   5996832.93686 2095303.59062 37.7331229707542 -122.453337845278 (37.7331229707542, -122.453337845278) 9 7 4 59 40
33889 209004 DPW Maintained 1 Eucalyptus globulus :: Blue Gum 56 156 Kensington Way 4 Sidewalk: Curb side : Yard Tree Private 2     13 Width 3ft   5994803.6888 2098556.09355 37.7419370183784 -122.460589057359 (37.7419370183784, -122.460589057359) 1 8 4 59 40
34158 191733 DPW Maintained 1 Eucalyptus globulus :: Blue Gum 56 100 Hampshire St 5 Front Yard : Yard Tree Private 2     25     6009990.50539 2107548.56259 37.7674903487254 -122.408711960091 (37.7674903487254, -122.408711960091) 8 4 8 28853 19
35559 122678 Undocumented 4 Eucalyptus globulus :: Blue Gum 56 701x Powhattan Ave 1 Sidewalk: Curb side : Cutout Tree Private 2     36 3x3   6008711 2098131 37.741560100881 -122.412471846631 (37.741560100881, -122.412471846631) 10 7 7 28859 2
35780 254316 DPW Maintained 1 Eucalyptus globulus :: Blue Gum 56 200X Junipero Serra Blvd 3 Median : Yard Tree Private 2       10x10   5991374 2095037 37.73207656946 -122.472191241156 (37.73207656946, -122.472191241156) 1 8 4 64 40
35915 208975 DPW Maintained 1 Eucalyptus globulus :: Blue Gum 56 100 Yerba Buena Ave 4 Sidewalk: Curb side : Yard Tree Private 2     31 Width 6ft   5994177.11325 2096643.32557 37.7366489660835 -122.462616818123 (37.7366489660835, -122.462616818123) 9 8 4 59 40
36331 256763 Undocumented 4 Eucalyptus globulus :: Blue Gum 56 1039 Hudson Ave 1 Sidewalk: Curb side : Cutout Tree Private 2       3x3   6018789 2095103 37.7338062313868 -122.377415095373 (37.7338062313868, -122.377415095373) 10 3 8 58 1
36671 208936 DPW Maintained 1 Eucalyptus globulus :: Blue Gum 56 3 Saint Francis Blvd 2 Sidewalk: Curb side : Yard Tree Private 2     15 Width 10ft   5991855.38456 2095971.03212 37.7346690339426 -122.470595009771 (37.7346690339426, -122.470595009771) 9 8 4 59 40
36885 246762 DPW Maintained 1 Eucalyptus globulus :: Blue Gum 56 70 Waltham St 6 Front Yard : Yard Tree Private 2     38     6009259.9688 2098886.63063 37.743665689828 -122.410627040331 (37.743665689828, -122.410627040331) 2 7 7 28859 2
36888 209029 DPW Maintained 1 Eucalyptus globulus :: Blue Gum 56 36 Martha Ave 6 Front Yard : Yard Tree Private 2     18     6000758.12976 2095576.10922 37.7340954490409 -122.439786968613 (37.7340954490409, -122.439786968613) 9 7 5 63 40
36995 254312 DPW Maintained 1 Eucalyptus globulus :: Blue Gum 56 190X Junipero Serra Blvd 4 Median : Yard Tree Private 2       10x10   5991377 2095081 37.732197556005 -122.472184075725 (37.732197556005, -122.472184075725) 1 8 4 64 40
37033 92037 Permitted Site 7 Eucalyptus globulus :: Blue Gum 56 10 Elk St 5 Sidewalk: Curb side : Cutout Tree Private 2       3x3 Permit Number 52176 5999970.9 2097826.1 37.7402285519688 -122.442670159752 (37.7402285519688, -122.442670159752) 2 7 5 63 7
37673 246758 DPW Maintained 1 Eucalyptus globulus :: Blue Gum 56 70 Waltham St 2 Front Yard : Yard Tree Private 2     45     6009165.37597 2098887.8964 37.7436638615084 -122.410954210088 (37.7436638615084, -122.410954210088) 2 7 7 28859 2
37827 208942 DPW Maintained 1 Eucalyptus globulus :: Blue Gum 56 200 Saint Francis Blvd 1 Sidewalk: Curb side : Yard Tree Private 2     32 Width 10ft   5992406.13159 2095989.66706 37.7347520323855 -122.468692262863 (37.7347520323855, -122.468692262863) 9 8 4 59 40
37863 224257 DPW Maintained 1 Eucalyptus globulus :: Blue Gum 56 355 Buena Vista Ave East 13 Sidewalk: Property side : Yard Tree Private 2     14 Width 3ft   6001064.07525 2107884.43165 37.7679085577502 -122.439611299541 (37.7679085577502, -122.439611299541) 15 5 5 29492 3
38371 254283 DPW Maintained 1 Eucalyptus globulus :: Blue Gum 56 80X Junipero Serra Blvd 7 Median : Yard Tree Private 2       3x3   5991405 2095520 37.733404559811 -122.472119261767 (37.733404559811, -122.472119261767) 1 8 4 64 40
40308 208955 DPW Maintained 1 Eucalyptus globulus :: Blue Gum 56 630 Saint Francis Blvd 1 Sidewalk: Curb side : Yard Tree Private 2     35 Width 8ft   5993530.97918 2095998.56422 37.7348413791301 -122.464803955838 (37.7348413791301, -122.464803955838) 9 8 4 59 40
41955 207763 DPW Maintained 1 Eucalyptus globulus :: Blue Gum 56 290 Santa Clara Ave 1 Sidewalk: Curb side : Yard Tree Private 2     36 Width 10ft   5993266.97338 2095443.21542 37.7333013044925 -122.465676373776 (37.7333013044925, -122.465676373776) 9 8 4 59 40
42039 207775 DPW Maintained 1 Eucalyptus globulus :: Blue Gum 56 110 Santa Clara Ave 1 Sidewalk: Curb side : Yard Tree Private 2     27 Width 10ft   5993244.34274 2096906.29835 37.737317260394 -122.465860883191 (37.737317260394, -122.465860883191) 1 8 4 59 40
42249 224253 DPW Maintained 1 Eucalyptus globulus :: Blue Gum 56 755 Sanchez St 6 Front Yard : Yard Tree Private 2     28 Width 3ft   6003620.82081 2103873.1752 37.7570397984623 -122.430481566473 (37.7570397984623, -122.430481566473) 2 4 5 28862 3
42456 191735 DPW Maintained 1 Eucalyptus globulus :: Blue Gum 56 100 Hampshire St 8 Front Yard : Yard Tree Private 2     27     6010009.09697 2107534.42743 37.7674525780981 -122.408646656734 (37.7674525780981, -122.408646656734) 8 4 8 28853 19
42550 208970 DPW Maintained 1 Eucalyptus globulus :: Blue Gum 56 20 Yerba Buena Ave 2 Sidewalk: Curb side : Yard Tree Private 2     28 Width 6ft   5993484.40904 2097144.77152 37.7379858937365 -122.465048184725 (37.7379858937365, -122.465048184725) 1 8 4 59 40
43440 92035 Permitted Site 7 Eucalyptus globulus :: Blue Gum 56 10 Elk St 3 Sidewalk: Curb side : Cutout Tree Private 2       3x3 Permit Number 52176 5999970.9 2097826.1 37.7402285519688 -122.442670159752 (37.7402285519688, -122.442670159752) 2 7 5 63 7
43919 113860 Undocumented 4 Eucalyptus globulus :: Blue Gum 56 456 HILL ST 2 Sidewalk: Curb side : Cutout Tree Private 2       3x3   6003369 2103347 37.755580778127 -122.431314899346 (37.755580778127, -122.431314899346) 2 4 5 28862 22
44214 208933 DPW Maintained 1 Eucalyptus globulus :: Blue Gum 56 405 Saint Francis Blvd 1 Sidewalk: Curb side : Yard Tree Private 2     31 Width 10ft   5992936.60702 2096064.26617 37.7349874937845 -122.466863664131 (37.7349874937845, -122.466863664131) 1 8 4 59 40
44574 208991 DPW Maintained 1 Eucalyptus globulus :: Blue Gum 56 45 Yerba Buena Ave 1 Sidewalk: Curb side : Yard Tree Private 2     28 Width 4ft   5993638.39674 2097082.374 37.7378234437858 -122.464511248112 (37.7378234437858, -122.464511248112) 1 8 4 59 40
44889 191727 DPW Maintained 1 Eucalyptus globulus :: Blue Gum 56 1790 23rd St 1 Sidewalk: Property side : Yard Tree Private 2     21     6013509.42079 2102917.94191 37.7549721419751 -122.396215837988 (37.7549721419751, -122.396215837988) 10 3 8 28856 29
45573 208969 DPW Maintained 1 Eucalyptus globulus :: Blue Gum 56 30 Yerba Buena Ave 1 Sidewalk: Curb side : Yard Tree Private 2     27 Width 6ft   5993545.78483 2097101.19005 37.7378697687758 -122.464832815983 (37.7378697687758, -122.464832815983) 1 8 4 59 40
45655 121204 DPW Maintained 1 Eucalyptus globulus :: Blue Gum 56 44 MacOndray Ln 1 Unaccepted Street : Cutout Tree Private 2     52     6008473.20212 2119153.5676 37.7992698007193 -122.41478152415 (37.7992698007193, -122.41478152415) 5 1 10 308 32
47282 207782 DPW Maintained 1 Eucalyptus globulus :: Blue Gum 56 260 Santa Clara Ave 1 Sidewalk: Curb side : Yard Tree Private 2     24 Width 10ft   5993076.07579 2096352.69881 37.7357875063795 -122.466402431535 (37.7357875063795, -122.466402431535) 1 8 4 59 40
47520 209045 DPW Maintained 1 Eucalyptus globulus :: Blue Gum 56 300 Melrose Ave 3 Side Yard : Yard Tree Private 2     88     5998032.35629 2095523.65591 37.7337958938523 -122.449206999226 (37.7337958938523, -122.449206999226) 9 7 4 59 40
47849 209028 DPW Maintained 1 Eucalyptus globulus :: Blue Gum 56 36 Martha Ave 5 Front Yard : Yard Tree Private 2     29     6000760.3597 2095574.56127 37.7340913256606 -122.439779148088 (37.7340913256606, -122.439779148088) 9 7 5 63 40
49183 208959 DPW Maintained 1 Eucalyptus globulus :: Blue Gum 56 601 Saint Francis Blvd 1 Sidewalk: Curb side : Yard Tree Private 2     28 Width 8ft   5993493.92403 2096119.04846 37.7351700624345 -122.46494081468 (37.7351700624345, -122.46494081468) 1 8 4 59 40
49989 207806 DPW Maintained 1 Eucalyptus globulus :: Blue Gum 56 35 Santa Clara Ave 2 Sidewalk: Curb side : Yard Tree Private 2     32 Width 10ft   5993241.00806 2097448.11917 37.7388047723291 -122.465911770435 (37.7388047723291, -122.465911770435) 1 8 4 59 40
50310 176345 DPW Maintained 1 Eucalyptus globulus :: Blue Gum 56 450 Raymond Ave 3 Sidewalk: Property side : Yard Tree Private 2     34     6008420.88631 2088405.51015 37.7148397004654 -122.412787554496 (37.7148397004654, -122.412787554496) 9 7 8 309 18
51052 207773 DPW Maintained 1 Eucalyptus globulus :: Blue Gum 56 80 Santa Clara Ave 1 Sidewalk: Curb side : Yard Tree Private 2     58 Width 10ft   5993272.22832 2097088.94625 37.7378203744176 -122.465777737259 (37.7378203744176, -122.465777737259) 1 8 4 59 40
51225 254298 DPW Maintained 1 Eucalyptus globulus :: Blue Gum 56 140 Junipero Serra Blvd 1 Median : Cutout Tree Private 2       3x3   5991388 2095260 37.73268968153 -122.472159089582 (37.73268968153, -122.472159089582) 1 8 4 64 40
51387 224267 DPW Maintained 1 Eucalyptus globulus :: Blue Gum 56 2300 22nd St 3 Front Yard : Yard Tree Private 2     26     6011260.20343 2103721.90369 37.7570542343818 -122.40405088815 (37.7570542343818, -122.40405088815) 10 4 8 28859 19
51836 209018 DPW Maintained 1 Eucalyptus globulus :: Blue Gum 56 33 Martha Ave 3 : Yard Tree Private 2     38     6000767.57935 2095529.42368 37.733967799282 -122.439750952539 (37.733967799282, -122.439750952539) 9 7 5 63 40
52709 191734 DPW Maintained 1 Eucalyptus globulus :: Blue Gum 56 100 Hampshire St 7 Front Yard : Yard Tree Private 2     22     6009976.80194 2107534.39117 37.7674506697311 -122.408758358812 (37.7674506697311, -122.408758358812) 8 4 8 28853 19
53008 209014 DPW Maintained 1 Eucalyptus globulus :: Blue Gum 56 412 Baden St 2 Side Yard : Yard Tree Private 2     7     6000787.79858 2095464.06576 37.733789492485 -122.439676364596 (37.733789492485, -122.439676364596) 9 7 5 63 40
55299 208919 DPW Maintained 1 Eucalyptus globulus :: Blue Gum 56 101 Saint Francis Blvd 1 Sidewalk: Curb side : Yard Tree Private 2     38 Width 10ft   5992247.91507 2096042.07051 37.734886777798 -122.469243079632 (37.734886777798, -122.469243079632) 1 8 4 59 40
56798 208958 DPW Maintained 1 Eucalyptus globulus :: Blue Gum 56 625 Saint Francis Blvd 2 Sidewalk: Curb side : Yard Tree Private 2     26 Width 8ft   5993531.51586 2096121.15742 37.7351780205546 -122.464811000239 (37.7351780205546, -122.464811000239) 1 8 4 59 40
56919 208997 DPW Maintained 1 Eucalyptus globulus :: Blue Gum 56 10 Yerba Buena Ave 1 Sidewalk: Curb side : Yard Tree Private 2     31 Width 4ft   5993343.64638 2097250.7379 37.7382687332076 -122.465542562746 (37.7382687332076, -122.465542562746) 1 8 4 59 40
57886 209012 DPW Maintained 1 Eucalyptus globulus :: Blue Gum 56 410 Baden St 1 Front Yard : Yard Tree Private 2     24     6000789.00569 2095372.0781 37.7335369844496 -122.439665598801 (37.7335369844496, -122.439665598801) 9 7 5 63 40
58186 105492 Undocumented 4 Eucalyptus globulus :: Blue Gum 56 1575 07TH AVE 6 Sidewalk: Curb side : Cutout Tree Private 2     3 3x3 Permit Number 773490 5993962.3 2104771.9 37.7589555970933 -122.463949378571 (37.7589555970933, -122.463949378571) 1 8 4 56 12
58428 209046 DPW Maintained 1 Eucalyptus globulus :: Blue Gum 56 301 Joost Ave 1 Sidewalk: Property side : Yard Tree Private 2     55 Width 10ft   5999983.24986 2094934.98428 37.7322909323756 -122.442419949729 (37.7322909323756, -122.442419949729) 9 7 4 63 40
58510 254319 Undocumented 4 Eucalyptus globulus :: Blue Gum 56 210 Junipero Serra Blvd 2 Median : Cutout Tree Private 2       10x10   5991371 2094995 37.7319610744091 -122.472198552297 (37.7319610744091, -122.472198552297) 1 8 4 64 40
59460 207755 DPW Maintained 1 Eucalyptus globulus :: Blue Gum 56 95 Kirkham St 6 Sidewalk: Property side : Yard Tree Private 2     43     5994788.04604 2105291.71815 37.7604304368423 -122.461131260407 (37.7604304368423, -122.461131260407) 15 5 4 56 12
59512 207781 DPW Maintained 1 Eucalyptus globulus :: Blue Gum 56 256 Santa Clara Ave 1 Sidewalk: Curb side : Yard Tree Private 2     19 Width 10ft   5993074.74882 2096403.4667 37.7359268257591 -122.466410707985 (37.7359268257591, -122.466410707985) 1 8 4 59 40
59596 224230 DPW Maintained 1 Eucalyptus globulus :: Blue Gum 56 1100 San Jose Ave 20 Front Yard : Yard Tree Private 2     9     6004850.15407 2096702.70071 37.7374208892559 -122.425719711103 (37.7374208892559, -122.425719711103) 2 7 5 63 7
59936 92040 Permitted Site 7 Eucalyptus globulus :: Blue Gum 56 10 Elk St 8 Sidewalk: Curb side : Cutout Tree Private 2       3x3 Permit Number 52176 5999970.9 2097826.1 37.7402285519688 -122.442670159752 (37.7402285519688, -122.442670159752) 2 7 5 63 7

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)
);