178 rows where qCaretaker_id = 1 and qSpecies_id = 5 sorted by Location

View and edit SQL

qCaretaker_id

  • DPW · 78
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)
179658 2505 DPW Maintained 1 Ceratonia siliqua :: Carob 5 1501 Burke Ave 1 Sidewalk: Curb side : Cutout Tree DPW 1     12 3X3   6016682.7889975 2098765.8378067 37.743747386446 -122.384952066789 (37.743747386446, -122.384952066789) 10 3 8 58 1
191865 2511 DPW Maintained 1 Ceratonia siliqua :: Carob 5 1501 Burke Ave 7 Sidewalk: Curb side : Cutout Tree DPW 1     12 3X3   6016682.7889975 2098765.8378067 37.743747386446 -122.384952066789 (37.743747386446, -122.384952066789) 10 3 8 58 1
175245 2498 DPW Maintained 1 Ceratonia siliqua :: Carob 5 1500 Burke Ave 2 Sidewalk: Curb side : Cutout Tree DPW 1     12 3X3   6016761.82696 2098799.80324 37.7438450200413 -122.384681135251 (37.7438450200413, -122.384681135251) 10 3 8 58 1
124745 2499 DPW Maintained 1 Ceratonia siliqua :: Carob 5 1500 Burke Ave 3 Sidewalk: Curb side : Cutout Tree DPW 1     12 3X3   6016750.97009 2098814.51662 37.7438848195436 -122.384719700863 (37.7438848195436, -122.384719700863) 10 3 8 58 1
126809 2500 DPW Maintained 1 Ceratonia siliqua :: Carob 5 1500 Burke Ave 4 Sidewalk: Curb side : Cutout Tree DPW 1     12 3X3   6016728.12134 2098825.14197 37.7439127309012 -122.384799447345 (37.7439127309012, -122.384799447345) 10 3 8 58 1
42634 2501 DPW Maintained 1 Ceratonia siliqua :: Carob 5 1500 Burke Ave 5 Sidewalk: Curb side : Cutout Tree DPW 1     12 3X3   6016709.08958 2098828.16093 37.7439199677279 -122.384865465686 (37.7439199677279, -122.384865465686) 10 3 8 58 1
192875 2502 DPW Maintained 1 Ceratonia siliqua :: Carob 5 1500 Burke Ave 6 Sidewalk: Curb side : Cutout Tree DPW 1     12 3X3   6016691.63378 2098834.3481 37.743935990944 -122.38492625536 (37.743935990944, -122.38492625536) 10 3 8 58 1
123783 2521 DPW Maintained 1 Ceratonia siliqua :: Carob 5 1555 Burke Ave 9 Sidewalk: Curb side : Cutout Tree DPW 1     12 3X3   6016567.75907 2098840.98498 37.7439473619958 -122.385355052105 (37.7439473619958, -122.385355052105) 10 3 8 58 1
161350 2503 DPW Maintained 1 Ceratonia siliqua :: Carob 5 1500 Burke Ave 7 Sidewalk: Curb side : Cutout Tree DPW 1     12 3X3   6016672.43224 2098847.72364 37.7439716553617 -122.384993582204 (37.7439716553617, -122.384993582204) 10 3 8 58 1
151412 2504 DPW Maintained 1 Ceratonia siliqua :: Carob 5 1500 Burke Ave 8 Sidewalk: Curb side : Cutout Tree DPW 1     12 3X3   6016654.18712 2098861.64491 37.7440088711085 -122.385057640012 (37.7440088711085, -122.385057640012) 10 3 8 58 1
84076 2520 DPW Maintained 1 Ceratonia siliqua :: Carob 5 1555 Burke Ave 8 Sidewalk: Curb side : Cutout Tree DPW 1     12 3X3   6016533.26 2098864.45764 37.744009904432 -122.385475978555 (37.744009904432, -122.385475978555) 10 3 8 58 1
122418 2519 DPW Maintained 1 Ceratonia siliqua :: Carob 5 1555 Burke Ave 7 Sidewalk: Curb side : Cutout Tree DPW 1     6 3X3   6016516.51157 2098877.59586 37.7440450526322 -122.385534806811 (37.7440450526322, -122.385534806811) 10 3 8 58 1
40094 2518 DPW Maintained 1 Ceratonia siliqua :: Carob 5 1555 Burke Ave 6 Sidewalk: Curb side : Cutout Tree DPW 1     6 3X3   6016498.61775 2098890.19219 37.7440786495081 -122.385597557904 (37.7440786495081, -122.385597557904) 10 3 8 58 1
5811 2517 DPW Maintained 1 Ceratonia siliqua :: Carob 5 1555 Burke Ave 5 Sidewalk: Curb side : Cutout Tree DPW 1     12 3X3   6016481.64243 2098901.45238 37.7441086284068 -122.385657039951 (37.7441086284068, -122.385657039951) 10 3 8 58 1
71087 189833 DPW Maintained 1 Ceratonia siliqua :: Carob 5 1570 Burke Ave 2 : Tree DPW 1   02/12/2016 12:00:00 AM 14 Width 3ft   6016585.78665 2098909.19771 37.7441356575455 -122.385297468507 (37.7441356575455, -122.385297468507) 10 3 8 58 1
41334 2516 DPW Maintained 1 Ceratonia siliqua :: Carob 5 1555 Burke Ave 4 Sidewalk: Curb side : Cutout Tree DPW 1     12 3X3   6016465.84234 2098914.75953 37.7441442928392 -122.38571260096 (37.7441442928392, -122.38571260096) 10 3 8 58 1
149727 2515 DPW Maintained 1 Ceratonia siliqua :: Carob 5 1555 Burke Ave 3 Sidewalk: Curb side : Cutout Tree DPW 1     6 3X3   6016446.65639 2098928.8879 37.7441820247861 -122.385779926925 (37.7441820247861, -122.385779926925) 10 3 8 58 1
120474 2514 DPW Maintained 1 Ceratonia siliqua :: Carob 5 1555 Burke Ave 2 Sidewalk: Curb side : Cutout Tree DPW 1     3 3X3   6016429.25086 2098939.95078 37.7442114380124 -122.385840882964 (37.7442114380124, -122.385840882964) 10 3 8 58 1
117722 2513 DPW Maintained 1 Ceratonia siliqua :: Carob 5 1555 Burke Ave 1 Sidewalk: Curb side : Cutout Tree DPW 1     12 3X3   6016387.51247 2098972.29453 37.7442979375022 -122.385987460765 (37.7442979375022, -122.385987460765) 10 3 8 58 1
81257 2540 DPW Maintained 1 Ceratonia siliqua :: Carob 5 1575 Burke Ave 8 Sidewalk: Curb side : Cutout Tree DPW 1     12 3X3   6016367.14673 2098986.82897 37.7443367189812 -122.386058894813 (37.7443367189812, -122.386058894813) 10 3 8 58 1
83022 2522 DPW Maintained 1 Ceratonia siliqua :: Carob 5 1555 Burke Ave 10 Sidewalk: Curb side : Cutout Tree DPW 1     12 3X3   6016344.0270005 2099019.0971083 37.7444240410894 -122.386141087772 (37.7444240410894, -122.386141087772) 10 3 8 58 1
79778 2524 DPW Maintained 1 Ceratonia siliqua :: Carob 5 1570 BURKE AVE 2 Sidewalk: Curb side : Cutout Tree DPW 1   02/12/2016 12:00:00 AM 12 3X3   6016449 2099041 37.7444899913278 -122.385779635787 (37.7444899913278, -122.385779635787) 10 3 8 58 1
155081 2536 DPW Maintained 1 Ceratonia siliqua :: Carob 5 1575 Burke Ave 4 Sidewalk: Curb side : Cutout Tree DPW 1     6 3X3   6016262.66893 2099065.69559 37.744547487686 -122.38642565812 (37.744547487686, -122.38642565812) 10 3 8 58 1
106760 2535 DPW Maintained 1 Ceratonia siliqua :: Carob 5 1575 Burke Ave 3 Sidewalk: Curb side : Cutout Tree DPW 1     6 3X3   6016210.73833 2099105.12284 37.7446528720358 -122.386607974081 (37.7446528720358, -122.386607974081) 10 3 8 58 1
139429 2541 DPW Maintained 1 Ceratonia siliqua :: Carob 5 1575 Burke Ave 9 Sidewalk: Curb side : Cutout Tree DPW 1     12 3X3   6016218.6051359 2099112.8628025 37.7446745598911 -122.386581311559 (37.7446745598911, -122.386581311559) 10 3 8 58 1
85869 2534 DPW Maintained 1 Ceratonia siliqua :: Carob 5 1575 Burke Ave 2 Sidewalk: Curb side : Cutout Tree DPW 1     6 3X3   6016196.15475 2099115.85615 37.7446815361299 -122.386659150015 (37.7446815361299, -122.386659150015) 10 3 8 58 1
70301 2533 DPW Maintained 1 Ceratonia siliqua :: Carob 5 1575 Burke Ave 1 Sidewalk: Curb side : Cutout Tree DPW 1     6 3X3   6016180.33193 2099126.30756 37.7447093575531 -122.386714591425 (37.7447093575531, -122.386714591425) 10 3 8 58 1
117844 188482 DPW Maintained 1 Ceratonia siliqua :: Carob 5 1580 Burke Ave 3 : Tree DPW 1   03/30/1990 12:00:00 AM 9 Width 4ft   6016171.38717 2099220.37618 37.7449671554124 -122.386752079638 (37.7449671554124, -122.386752079638) 10 3 8 58 1
33787 2545 DPW Maintained 1 Ceratonia siliqua :: Carob 5 1590X Burke Ave 2 Sidewalk: Curb side : Cutout Tree DPW 1   03/30/1990 12:00:00 AM 12 3X3   6016148.3291237 2099227.8294693 37.7449863439757 -122.386832330586 (37.7449863439757, -122.386832330586) 10 3 8 58 1
109158 2546 DPW Maintained 1 Ceratonia siliqua :: Carob 5 1590X Burke Ave 4 Sidewalk: Curb side : Cutout Tree DPW 1     12 3X3   6016148.3291237 2099227.8294693 37.7449863439757 -122.386832330586 (37.7449863439757, -122.386832330586) 10 3 8 58 1
175659 225049 DPW Maintained 1 Ceratonia siliqua :: Carob 5 500x 27th St 22 Median : Cutout Tree DPW 1     6 Width 4ft   6002919.63953 2100068.30287 37.7465527734974 -122.432634735922 (37.7465527734974, -122.432634735922) 2 7 5 63 22
31579 225050 DPW Maintained 1 Ceratonia siliqua :: Carob 5 500x 27th St 24 Median : Cutout Tree DPW 1     11 Width 4ft   6002949.31338 2100070.05084 37.7465592558077 -122.432532251866 (37.7465592558077, -122.432532251866) 2 7 5 63 22
32130 5658 DPW Maintained 1 Ceratonia siliqua :: Carob 5 1349-1349 Dolores St 1 Sidewalk: Curb side : Cutout Tree DPW 1     100 3X3   6005239.88286 2100530.07402 37.7479520016853 -122.42464442051 (37.7479520016853, -122.42464442051) 2 4 5 28859 19
51567 20965 DPW Maintained 1 Ceratonia siliqua :: Carob 5 2002X Sunset Blvd 5 Sidewalk: Curb side : Cutout Tree DPW 1     3 40   5984887.6165706 2101567.3225095 37.7496295616808 -122.495097123245 (37.7496295616808, -122.495097123245) 1 8 3 29491 35
55015 20969 DPW Maintained 1 Ceratonia siliqua :: Carob 5 2002X Sunset Blvd 9 Sidewalk: Curb side : Cutout Tree DPW 1     3 40   5984887.6165706 2101567.3225095 37.7496295616808 -122.495097123245 (37.7496295616808, -122.495097123245) 1 8 3 29491 35
124717 20967 DPW Maintained 1 Ceratonia siliqua :: Carob 5 2002X Sunset Blvd 7 Sidewalk: Curb side : Cutout Tree DPW 1     3 40   5984887.6165706 2101567.3225095 37.7496295616808 -122.495097123245 (37.7496295616808, -122.495097123245) 1 8 3 29491 35
62291 5529 DPW Maintained 1 Ceratonia siliqua :: Carob 5 895 Dolores St 1 Sidewalk: Curb side : Cutout Tree DPW 1     100 4X4   6005093.86648 2103161.82188 37.7551699235695 -122.425336590916 (37.7551699235695, -122.425336590916) 2 4 5 28859 19
149886 5523 DPW Maintained 1 Ceratonia siliqua :: Carob 5 865 Dolores St 2 Sidewalk: Curb side : Cutout Tree DPW 1     50 3X3   6005084.41522 2103351.40166 37.7556899313628 -122.425382766602 (37.7556899313628, -122.425382766602) 2 4 5 28859 19
27880 438 DPW Maintained 1 Ceratonia siliqua :: Carob 5 792X Dolores St 2 Sidewalk: Curb side : Cutout Tree DPW 1     80 6   6004975.0011312 2103729.1085203 37.7567208435744 -122.425788038834 (37.7567208435744, -122.425788038834) 2 4 5 28862 3
131158 5479 DPW Maintained 1 Ceratonia siliqua :: Carob 5 695 Dolores St 1 Sidewalk: Curb side : Cutout Tree DPW 1     20 8   6005031.79334 2104320.15384 37.758346924379 -122.425633695438 (37.758346924379, -122.425633695438) 2 4 5 28859 19
77058 222893 DPW Maintained 1 Ceratonia siliqua :: Carob 5 301 Dolores St 2 Sidewalk: Curb side : Cutout Tree DPW 1     24 Width 4ft   6004914.2278 2106488.73534 37.7642946914815 -122.426194676362 (37.7642946914815, -122.426194676362) 8 4 5 28859 19
182657 5384 DPW Maintained 1 Ceratonia siliqua :: Carob 5 325X Dolores St 2 Sidewalk: Curb side : Cutout Tree DPW 1     90 4X4   6004919.4864142 2106495.5645768 37.7643137401636 -122.426176974515 (37.7643137401636, -122.426176974515) 8 4 5 28859 19
56518 237914 DPW Maintained 1 Ceratonia siliqua :: Carob 5 1001 Stanyan St 1 Sidewalk: Curb side : Cutout Tree DPW 1     21 Width 4ft   5997227 2107052 37.7654037766697 -122.452823145368 (37.7654037766697, -122.452823145368) 15 5 11 29492 12
146708 116858 DPW Maintained 1 Ceratonia siliqua :: Carob 5 180 NOE ST 1 Sidewalk: Curb side : Cutout Tree DPW 1     14 3x3   6002788 2107242 37.7662425648461 -122.433602528192 (37.7662425648461, -122.433602528192) 15 5 5 28862 3
18931 16634 DPW Maintained 1 Ceratonia siliqua :: Carob 5 158 Noe St 1 Sidewalk: Curb side : Cutout Tree DPW 1     18 4X4   6002846.26234 2107315.61995 37.7664480128774 -122.433406271499 (37.7664480128774, -122.433406271499) 15 5 5 28862 3
2297 16623 DPW Maintained 1 Ceratonia siliqua :: Carob 5 136 Noe St 1 Sidewalk: Curb side : Cutout Tree DPW 1     18 3x3   6002840.1476308 2107468.9628395 37.7668687081336 -122.433438380285 (37.7668687081336, -122.433438380285) 15 5 5 28862 3
62764 16626 DPW Maintained 1 Ceratonia siliqua :: Carob 5 138 Noe St 1 Sidewalk: Curb side : Cutout Tree DPW 1   02/02/2001 12:00:00 AM 21 3X3   6002836.08721 2107485.6498 37.7669142960875 -122.43345361721 (37.7669142960875, -122.43345361721) 15 5 5 28862 3
187922 10409 DPW Maintained 1 Ceratonia siliqua :: Carob 5 1398 HAIGHT ST 2 Sidewalk: Curb side : Cutout Tree DPW 1     24 3x3   5999436 2108778 37.7702692735678 -122.445306860847 (37.7702692735678, -122.445306860847) 15 5 11 29492 9
98842 22886 DPW Maintained 1 Ceratonia siliqua :: Carob 5 95X Valencia St 2 Sidewalk: Curb side : Cutout Tree DPW 1     30 3x3   6006042.93395 2109155.55847 37.7716808854236 -122.422480302267 (37.7716808854236, -122.422480302267) 8 2 9 28853 19
68954 7418 DPW Maintained 1 Ceratonia siliqua :: Carob 5 1090 Folsom St 2 Sidewalk: Curb side : Cutout Tree DPW 1     12 3X3   6010342.8854 2110986.7114 37.7769504410171 -122.407735574616 (37.7769504410171, -122.407735574616) 14 2 9 28853 34
99086 7417 DPW Maintained 1 Ceratonia siliqua :: Carob 5 1090 Folsom St 1 Sidewalk: Curb side : Cutout Tree DPW 1   01/23/2003 12:00:00 AM 6 3X3   6010360.059 2111002.9309 37.7769959373466 -122.407677309481 (37.7769959373466, -122.407677309481) 14 2 9 28853 34
175440 7419 DPW Maintained 1 Ceratonia siliqua :: Carob 5 1090 Folsom St 3 Sidewalk: Curb side : Cutout Tree DPW 1     50 3X3   6010341.13591 2111005.37017 37.777001575706 -122.407742942642 (37.777001575706, -122.407742942642) 14 2 9 28853 34
25251 14688 DPW Maintained 1 Ceratonia siliqua :: Carob 5 775 McAllister St 3 Sidewalk: Curb side : Cutout Tree DPW 1     26 4x4   6005346.74925 2111820.94662 37.7789600951073 -122.425078130411 (37.7789600951073, -122.425078130411) 7 9 11 28852 41
36977 14687 DPW Maintained 1 Ceratonia siliqua :: Carob 5 775 McAllister St 2 Sidewalk: Curb side : Cutout Tree DPW 1     24 4x4   6005346.74925 2111820.94662 37.7789600951073 -122.425078130411 (37.7789600951073, -122.425078130411) 7 9 11 28852 41
55304 14686 DPW Maintained 1 Ceratonia siliqua :: Carob 5 775 McAllister St 1 Sidewalk: Curb side : Cutout Tree DPW 1     16 4X4   6005447.7824 2111997.5051 37.7794505882327 -122.424741179621 (37.7794505882327, -122.424741179621) 7 9 11 28852 41
15625 27616 DPW Maintained 1 Ceratonia siliqua :: Carob 5 775 McAllister St 4 Sidewalk: Curb side : Cutout Tree DPW 1     24 4x4   6005483.48508 2112000.60744 37.7794611228941 -122.424617889559 (37.7794611228941, -122.424617889559) 7 9 11 28852 41
169246 14640 DPW Maintained 1 Ceratonia siliqua :: Carob 5 600X McAllister St 3 Sidewalk: Curb side : Cutout Tree DPW 1     18 4x4   6006169.26455 2112150.7692 37.779912136471 -122.422256155719 (37.779912136471, -122.422256155719) 7 9 11 28852 41
121999 18922 DPW Maintained 1 Ceratonia siliqua :: Carob 5 2620 SACRAMENTO ST 1 Sidewalk: Curb side : Cutout Tree DPW 1     12 3x3   6002038.8 2115762.8 37.7895960030005 -122.436803887406 (37.7895960030005, -122.436803887406) 13 6 1 29490 27
56233 18865 DPW Maintained 1 Ceratonia siliqua :: Carob 5 2230 Sacramento St 2 Sidewalk: Curb side : Cutout Tree DPW 1     12 3X3   6003863.26827 2115999.97726 37.7903507527417 -122.430508349195 (37.7903507527417, -122.430508349195) 13 9 1 29490 27
20273 18860 DPW Maintained 1 Ceratonia siliqua :: Carob 5 2212 Sacramento St 2 Sidewalk: Curb side : Cutout Tree DPW 1     12 3X3   6004055.90045 2116026.39415 37.7904341972353 -122.429843740294 (37.7904341972353, -122.429843740294) 13 9 1 29490 27
105990 18859 DPW Maintained 1 Ceratonia siliqua :: Carob 5 2212 Sacramento St 1 Sidewalk: Curb side : Cutout Tree DPW 1   10/13/1992 12:00:00 AM 12 3X3   6004082.46062 2116030.31556 37.7904464684691 -122.429752123658 (37.7904464684691, -122.429752123658) 13 9 1 29490 27
93762 15124 DPW Maintained 1 Ceratonia siliqua :: Carob 5 300 Mission St 4 Sidewalk: Curb side : Cutout Tree DPW 1     14 2X2   6013752.67684 2116000.07901 37.7909062865319 -122.396291437927 (37.7909062865319, -122.396291437927) 12 2 9 28855 6
72975 15123 DPW Maintained 1 Ceratonia siliqua :: Carob 5 300 Mission St 3 Sidewalk: Curb side : Cutout Tree DPW 1     14 2X2   6013765.88916 2116013.74101 37.7909445343765 -122.396246681474 (37.7909445343765, -122.396246681474) 12 2 9 28855 6
95233 15122 DPW Maintained 1 Ceratonia siliqua :: Carob 5 300 Mission St 2 Sidewalk: Curb side : Cutout Tree DPW 1     8 2X2   6013811.40838 2116056.32171 37.7910639837629 -122.396092171091 (37.7910639837629, -122.396092171091) 12 2 9 28855 6
35126 15121 DPW Maintained 1 Ceratonia siliqua :: Carob 5 300 Mission St 1 Sidewalk: Curb side : Cutout Tree DPW 1     18 2X2   6013826.37134 2116069.93693 37.7911022004845 -122.396041353962 (37.7911022004845, -122.396041353962) 12 2 9 28855 6
19339 21778 DPW Maintained 1 Ceratonia siliqua :: Carob 5 2500X Taylor St 3 Sidewalk: Curb side : Cutout Tree DPW 1     12 5X5   6008409.45282 2121407.87429 37.8054559800011 -122.415161778523 (37.8054559800011, -122.415161778523) 5 1 10 308 23
99094 21776 DPW Maintained 1 Ceratonia siliqua :: Carob 5 2500X Taylor St 1 Sidewalk: Curb side : Cutout Tree DPW 1     12 3X3   6008409.45282 2121407.87429 37.8054559800011 -122.415161778523 (37.8054559800011, -122.415161778523) 5 1 10 308 23
135227 21781 DPW Maintained 1 Ceratonia siliqua :: Carob 5 2550X Taylor St 1 Sidewalk: Curb side : Cutout Tree DPW 1   08/12/2011 12:00:00 AM 3 4x4   6008458.56586 2121488.77145 37.8056808631332 -122.41499754514 (37.8056808631332, -122.41499754514) 3 1 10 308 23
176301 21784 DPW Maintained 1 Ceratonia siliqua :: Carob 5 2550X Taylor St 4 Sidewalk: Curb side : Cutout Tree DPW 1   02/11/2016 12:00:00 AM 12 4X4   6008458.56586 2121488.77145 37.8056808631332 -122.41499754514 (37.8056808631332, -122.41499754514) 3 1 10 308 23
34503 21789 DPW Maintained 1 Ceratonia siliqua :: Carob 5 2585 Taylor St 4 Sidewalk: Curb side : Cutout Tree DPW 1   05/20/2015 12:00:00 AM 3 4X4   6008161.90241 2121549.79462 37.8058317424248 -122.41602851934 (37.8058317424248, -122.41602851934) 5 1 10 308 23
71054 21785 DPW Maintained 1 Ceratonia siliqua :: Carob 5 2585 Taylor St 1 Sidewalk: Curb side : Cutout Tree DPW 1     12 4X4   6008161.90241 2121549.79462 37.8058317424248 -122.41602851934 (37.8058317424248, -122.41602851934) 5 1 10 308 23
36850 21792 DPW Maintained 1 Ceratonia siliqua :: Carob 5 2598 Taylor St 1 Sidewalk: Curb side : Cutout Tree DPW 1     12 4X4   6008439.13676 2121624.27905 37.8060518410095 -122.415074380155 (37.8060518410095, -122.415074380155) 3 1 10 308 23
100104 21793 DPW Maintained 1 Ceratonia siliqua :: Carob 5 2598 Taylor St 2 Sidewalk: Curb side : Cutout Tree DPW 1     12 4X4   6008439.13676 2121624.27905 37.8060518410095 -122.415074380155 (37.8060518410095, -122.415074380155) 3 1 10 308 23
142913 21795 DPW Maintained 1 Ceratonia siliqua :: Carob 5 2598 Taylor St 4 Sidewalk: Curb side : Cutout Tree DPW 1     12 4X4   6008439.13676 2121624.27905 37.8060518410095 -122.415074380155 (37.8060518410095, -122.415074380155) 3 1 10 308 23
145684 21794 DPW Maintained 1 Ceratonia siliqua :: Carob 5 2598 Taylor St 3 Sidewalk: Curb side : Cutout Tree DPW 1     21 4X4   6008439.13676 2121624.27905 37.8060518410095 -122.415074380155 (37.8060518410095, -122.415074380155) 3 1 10 308 23
85699 11179 DPW Maintained 1 Ceratonia siliqua :: Carob 5 2750X Hyde St 1 Sidewalk: Curb side : Cutout Tree DPW 1     36 3x3   6006893.59102 2121789.4662 37.8064184289444 -122.4204347354 (37.8064184289444, -122.4204347354) 5 1 1 28858 32
140473 11180 DPW Maintained 1 Ceratonia siliqua :: Carob 5 2750X Hyde St 2 Sidewalk: Curb side : Cutout Tree DPW 1     12 3X3   6006892.18437 2121805.14198 37.806461391357 -122.420440716763 (37.806461391357, -122.420440716763) 5 1 1 28858 32
95994 11181 DPW Maintained 1 Ceratonia siliqua :: Carob 5 2750X Hyde St 3 Sidewalk: Curb side : Cutout Tree DPW 1     14 3X3   6006890.68476 2121823.94924 37.8065129467732 -122.420447242256 (37.8065129467732, -122.420447242256) 5 1 1 28858 32

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