71 rows where qCareAssistant = "FUF" and qSpecies_id = 5

View and edit SQL

qCareAssistant

  • FUF · 71
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)
4137 61685 DPW Maintained 1 Ceratonia siliqua :: Carob 5 34 Ceres St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 11/29/1984 12:00:00 AM 11   Permit Number 21682 6013864.09066 2093969.56082 37.7304214900476 -122.394362775032 (37.7304214900476, -122.394362775032) 10 3 8 58 1
8282 80561 DPW Maintained 1 Ceratonia siliqua :: Carob 5 1820X Palou Ave 4 Sidewalk: Curb side : Cutout Tree Private 2 FUF   15     6013651.87309 2096197.81138 37.7365280090438 -122.395252475224 (37.7365280090438, -122.395252475224) 10 3 8 58 1
14153 61726 DPW Maintained 1 Ceratonia siliqua :: Carob 5 28 Ceres St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 12/14/1984 12:00:00 AM 9   Permit Number 21728 6013869.02725 2093995.24936 37.7304922999628 -122.39434750634 (37.7304922999628, -122.39434750634) 10 3 8 58 1
18873 61724 DPW Maintained 1 Ceratonia siliqua :: Carob 5 18 Ceres St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 12/17/1984 12:00:00 AM 8   Permit Number 21726 6013883.84127 2094072.5147 37.7307052783181 -122.394301699376 (37.7307052783181, -122.394301699376) 10 3 8 58 1
20304 49779 Permitted Site 7 Ceratonia siliqua :: Carob 5 241@ BLANKEN Tocoloma Ave 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 06/09/2003 12:00:00 AM     Permit Number 46565 6012711.25696991 2087289.78103258 37.7120160109599 -122.397879925295 (37.7120160109599, -122.397879925295) 10 3 8 309 1
20598 60264 Permitted Site 7 Ceratonia siliqua :: Carob 5 2804 21st St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 09/15/1984 12:00:00 AM     Permit Number 19820 6009362.55423892 2103960.83669592 37.7576040815568 -122.410630580485 (37.7576040815568, -122.410630580485) 2 4 7 28859 19
20659 59670 Permitted Site 7 Ceratonia siliqua :: Carob 5 98X PARNASSUS AVE 3 Sidewalk: Curb side : Cutout Tree Private 2 FUF 08/09/1993 12:00:00 AM 15 3x3 Permit Number 32228 5998297 2106864 37.7649488326227 -122.449108733904 (37.7649488326227, -122.449108733904) 15 5 11 29492 9
24468 57556 Permitted Site 7 Ceratonia siliqua :: Carob 5 57 Lundy's Ln 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 12/08/1986 12:00:00 AM     Permit Number 23627 6007019.50965831 2099220.3784742 37.7444562195491 -122.418397682663 (37.7444562195491, -122.418397682663) 2 7 7 28859 2
25806 47316 Permitted Site 7 Ceratonia siliqua :: Carob 5 2524 19th St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 05/10/2002 12:00:00 AM     Permit Number 45245 6010338.92838604 2105074.55283943 37.7607167883884 -122.407332377331 (37.7607167883884, -122.407332377331) 10 4 8 28859 19
26541 62275 Permitted Site 7 Ceratonia siliqua :: Carob 5 141 Webster St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 10/09/1985 12:00:00 AM     Permit Number 22411 6004215.98521889 2109270.59348358 37.771893510559 -122.428808033039 (37.771893510559, -122.428808033039) 7 9 11 29492 10
33302 60693 Permitted Site 7 Ceratonia siliqua :: Carob 5 2762 22nd St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 03/05/1983 12:00:00 AM     Permit Number 20336 6009623.17116786 2103391.2059206 37.7560546117591 -122.409689051741 (37.7560546117591, -122.409689051741) 2 4 7 28859 19
34794 83038 Undocumented 4 Ceratonia siliqua :: Carob 5 100X Cargo Way 14 Sidewalk: Curb side : Cutout Tree Private 2 FUF 02/04/2006 12:00:00 AM       6018593.33009 2097780.6594 37.7411477742489 -122.378277419086 (37.7411477742489, -122.378277419086) 10 3 8 58 1
35310 47061 Permitted Site 7 Ceratonia siliqua :: Carob 5 114 Webster St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 05/02/2002 12:00:00 AM   3x3 Permit Number 45048 6004275.94265243 2109216.94695979 37.7717496035942 -122.428596811267 (37.7717496035942, -122.428596811267) 7 9 11 28852 10
35427 35826 Permitted Site 7 Ceratonia siliqua :: Carob 5 658 Edinburg St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 10/30/2003 12:00:00 AM     Permit Number 47147 6002331.25520589 2089974.9119099 37.7188052443929 -122.433947949751 (37.7188052443929, -122.433947949751) 9 7 6 28861 5
35579 63232 Permitted Site 7 Ceratonia siliqua :: Carob 5 53 Lundy's Ln 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 01/13/1987 12:00:00 AM     Permit Number 23779 6007031.32644483 2099242.02691528 37.7445163265111 -122.418358357204 (37.7445163265111, -122.418358357204) 2 7 7 28859 2
36033 37053 Permitted Site 7 Ceratonia siliqua :: Carob 5 231 Duncan St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 07/08/2015 12:00:00 AM 3 6x9 Permit Number 775674 6005030.06979159 2099868.96006137 37.7461248828886 -122.425322907066 (37.7461248828886, -122.425322907066) 2 7 5 63 22
37593 63223 Permitted Site 7 Ceratonia siliqua :: Carob 5 74 Prospect Ave 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 11/08/1986 12:00:00 AM     Permit Number 23767 6007024.24525419 2099097.21630379 37.7441183104389 -122.418372576893 (37.7441183104389, -122.418372576893) 2 7 7 28859 2
41267 63222 Permitted Site 7 Ceratonia siliqua :: Carob 5 76 Prospect Ave 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 01/06/1987 12:00:00 AM     Permit Number 23766 6007018.22684623 2099086.03719365 37.7440872763149 -122.418392594768 (37.7440872763149, -122.418392594768) 2 7 7 28859 2
43480 65221 Permitted Site 7 Ceratonia siliqua :: Carob 5 411 Paris St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 07/29/1989 12:00:00 AM     Permit Number 28008 6002203.13463286 2091195.37244375 37.7221490848593 -122.434478026037 (37.7221490848593, -122.434478026037) 9 7 6 28861 5
46212 61684 Permitted Site 7 Ceratonia siliqua :: Carob 5 49 Ceres St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 01/12/1985 12:00:00 AM     Permit Number 21681 6013901.59422939 2093898.15648128 37.7302275129585 -122.394228121663 (37.7302275129585, -122.394228121663) 10 3 8 58 1
47785 63130 Permitted Site 7 Ceratonia siliqua :: Carob 5 26 Prospect Ave 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 12/11/1986 12:00:00 AM     Permit Number 23644 6007187.15982152 2099399.82780325 37.7449583833589 -122.417830699083 (37.7449583833589, -122.417830699083) 2 7 7 28859 2
50898 49041 Permitted Site 7 Ceratonia siliqua :: Carob 5 406 Vicksburg St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 01/07/2003 12:00:00 AM     Permit Number 46216 6004132.32350443 2101573.22879489 37.7507536483556 -122.428548658976 (37.7507536483556, -122.428548658976) 2 4 5 28862 22
52185 63117 Permitted Site 7 Ceratonia siliqua :: Carob 5 72 Lundy's Ln 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 12/08/1986 12:00:00 AM     Permit Number 23624 6006928.92708318 2099162.96302102 37.7442934699851 -122.418706828381 (37.7442934699851, -122.418706828381) 2 7 7 28859 2
53701 51842 Permitted Site 7 Ceratonia siliqua :: Carob 5 34 Lundy's Ln 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 12/09/1986 12:00:00 AM     Permit Number 48069 6007044.58832094 2099374.8552715 37.7448817898933 -122.418321916232 (37.7448817898933, -122.418321916232) 2 7 7 28859 2
56519 44334 Permitted Site 7 Ceratonia siliqua :: Carob 5 57 Webster St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 03/06/2001 12:00:00 AM     Permit Number 43719 6004283.91720992 2108781.91004669 37.770555549309 -122.428538212023 (37.770555549309, -122.428538212023) 7 9 11 29492 10
62864 62271 Permitted Site 7 Ceratonia siliqua :: Carob 5 108 Webster St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 10/09/1985 12:00:00 AM     Permit Number 22405 6004283.36290773 2109163.56782991 37.7716034574246 -122.428567338549 (37.7716034574246, -122.428567338549) 7 9 11 28852 10
66042 60257 Permitted Site 7 Ceratonia siliqua :: Carob 5 911 Florida St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 09/10/1982 12:00:00 AM     Permit Number 19811 6009422.17813465 2103864.55146626 37.757343046708 -122.410417577389 (37.757343046708, -122.410417577389) 2 4 7 28859 19
67810 41699 Permitted Site 7 Ceratonia siliqua :: Carob 5 2 Mizpah St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 06/19/2000 12:00:00 AM     Permit Number 42149 6001021.55719924 2096664.38095079 37.7370985809646 -122.438954184383 (37.7370985809646, -122.438954184383) 2 7 5 63 7
69587 67184 Permitted Site 7 Ceratonia siliqua :: Carob 5 912 Clayton St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 05/06/1992 12:00:00 AM     Permit Number 30631 5998760.11857013 2106856.81248154 37.7649555743728 -122.447506412542 (37.7649555743728, -122.447506412542) 15 5 11 29492 9
72277 58315 Permitted Site 7 Ceratonia siliqua :: Carob 5 86 Lundy's Ln 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 12/08/1986 12:00:00 AM     Permit Number 23623 6006886.31504247 2099084.89744452 37.7440767201845 -122.418848636603 (37.7440767201845, -122.418848636603) 2 7 7 28859 2
75940 51298 DPW Maintained 1 Ceratonia siliqua :: Carob 5 300X Golden Gate Ave 3 Sidewalk: Curb side : Cutout Tree Private 2 FUF 09/07/2004 12:00:00 AM 7   Permit Number 47670 6008009.38054 2112753.19289 37.7816698695126 -122.415933029587 (37.7816698695126, -122.415933029587) 7 10 9 28852 36
82514 63116 Permitted Site 7 Ceratonia siliqua :: Carob 5 115 Lundy's Ln 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 12/08/1986 12:00:00 AM     Permit Number 23622 6006844.85682717 2098899.69149034 37.7435658517454 -122.418978856767 (37.7435658517454, -122.418978856767) 2 7 7 28859 2
89492 63739 Permitted Site 7 Ceratonia siliqua :: Carob 5 665 Page St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 10/22/1988 12:00:00 AM     Permit Number 24410 6003393.73641512 2109629.91106527 37.7728335359212 -122.431677907074 (37.7728335359212, -122.431677907074) 15 9 11 29492 10
93446 67186 Permitted Site 7 Ceratonia siliqua :: Carob 5 281 Carl St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 05/06/1992 12:00:00 AM     Permit Number 30634 5996869.12207945 2106987.0610707 37.7652049569046 -122.454056265196 (37.7652049569046, -122.454056265196) 15 5 11 29492 12
95517 52077 Permitted Site 7 Ceratonia siliqua :: Carob 5 2959 23rd St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 08/19/2005 12:00:00 AM     Permit Number 48273 6009147.75263717 2102727.30105861 37.7542050255745 -122.411286316307 (37.7542050255745, -122.411286316307) 2 4 7 28859 19
102569 62273 Permitted Site 7 Ceratonia siliqua :: Carob 5 123 Webster St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 10/09/1985 12:00:00 AM     Permit Number 22409 6004226.44756002 2109195.3304156 37.7716874486567 -122.428766476737 (37.7716874486567, -122.428766476737) 7 9 11 29492 10
107061 47237 DPW Maintained 1 Ceratonia siliqua :: Carob 5 1200X Fitzgerald Ave 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 05/09/2002 12:00:00 AM 9 3x3 Permit Number 45189 6014656.8506 2090563.7281 37.721113790544 -122.391384069594 (37.721113790544, -122.391384069594) 10 3 8 58 1
112219 60684 Permitted Site 7 Ceratonia siliqua :: Carob 5 2969 23rd St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 03/05/1983 12:00:00 AM     Permit Number 20325 6009095.19054271 2102724.34950865 37.7541939732112 -122.411467881257 (37.7541939732112, -122.411467881257) 2 4 7 28859 19
112435 47241 Permitted Site 7 Ceratonia siliqua :: Carob 5 1000X Jamestown Ave 3 Sidewalk: Curb side : Cutout Tree Private 2 FUF 05/09/2002 12:00:00 AM 8 3x3 Permit Number 45190 6014093.2543098 2089771.82198012 37.718908077116 -122.393276886105 (37.718908077116, -122.393276886105) 10 3 8 58 1
112903 62270 Permitted Site 7 Ceratonia siliqua :: Carob 5 102 Webster St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 10/09/1985 12:00:00 AM     Permit Number 22404 6004290.78316217 2109110.18870614 37.7714573112605 -122.42853786595 (37.7714573112605, -122.42853786595) 7 9 11 28852 10
119313 65609 DPW Maintained 1 Ceratonia siliqua :: Carob 5 259 Maynard St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 02/06/1990 12:00:00 AM 12   Permit Number 28514 6005079.93888 2093817.02687 37.7295104552453 -122.424720013038 (37.7295104552453, -122.424720013038) 9 7 6 28861 5
119539 60259 Permitted Site 7 Ceratonia siliqua :: Carob 5 900 Florida St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 08/26/1989 12:00:00 AM     Permit Number 28050 6009367.15001104 2103917.51160129 37.7574853782949 -122.410611626923 (37.7574853782949, -122.410611626923) 2 4 7 28859 19
120772 51301 Permitted Site 7 Ceratonia siliqua :: Carob 5 101 Hyde St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 11/20/2004 12:00:00 AM     Permit Number 47670 6008105.70875607 2112751.56982087 37.7816708281319 -122.415599663608 (37.7816708281319, -122.415599663608) 7 10 9 28852 36
120856 63118 Permitted Site 7 Ceratonia siliqua :: Carob 5 70 Lundy's Ln 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 12/08/1986 12:00:00 AM     Permit Number 23625 6006935.01451866 2099174.11524824 37.7443244342333 -122.418686569992 (37.7443244342333, -122.418686569992) 2 7 7 28859 2
123502 59722 Permitted Site 7 Ceratonia siliqua :: Carob 5 2905 21st St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 09/14/1984 12:00:00 AM     Permit Number 19154 6008831.83417105 2103879.56302809 37.757351153159 -122.41246028798 (37.757351153159, -122.41246028798) 2 4 7 28859 19
131314 60288 Permitted Site 7 Ceratonia siliqua :: Carob 5 2932 23rd St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 10/09/1982 12:00:00 AM     Permit Number 19852 6009284.44431761 2102786.94037008 37.754376447105 -122.410817812439 (37.754376447105, -122.410817812439) 2 4 7 28859 19
131347 62272 Permitted Site 7 Ceratonia siliqua :: Carob 5 113 Webster St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 10/09/1985 12:00:00 AM     Permit Number 22406 6004233.40404883 2109145.28748516 37.7715504366717 -122.428738845772 (37.7715504366717, -122.428738845772) 7 9 11 29492 10
134432 32473 DPW Maintained 1 Ceratonia siliqua :: Carob 5 144 Lower Ter 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 10/10/1996 12:00:00 AM 9   Permit Number 36981 6000263.91054 2106227.11632 37.7633124078752 -122.442259981907 (37.7633124078752, -122.442259981907) 15 5 5 28862 3
136811 60690 Permitted Site 7 Ceratonia siliqua :: Carob 5 2773 22nd St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 03/05/1983 12:00:00 AM     Permit Number 20333 6009572.74299755 2103336.33183864 37.7559011138434 -122.409859576548 (37.7559011138434, -122.409859576548) 2 4 7 28859 19
138537 47239 DPW Maintained 1 Ceratonia siliqua :: Carob 5 1004X Jamestown Ave 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 05/09/2002 12:00:00 AM 8 3x3 Permit Number 45190 6013984.3411 2089670.3406 37.7186233778889 -122.393646260173 (37.7186233778889, -122.393646260173) 10 3 8 58 1
142864 32581 DPW Maintained 1 Ceratonia siliqua :: Carob 5 1314 33rd Ave 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 10/22/1996 12:00:00 AM 4   Permit Number 37055 5985876.1437 2106257.7648 37.7625660493627 -122.492024105228 (37.7625660493627, -122.492024105228) 1 8 3 56 35
143674 60260 Permitted Site 7 Ceratonia siliqua :: Carob 5 2844 21st St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 09/15/1984 12:00:00 AM     Permit Number 19815 6009158.9675903 2103949.64001782 37.757561921733 -122.411333877594 (37.757561921733, -122.411333877594) 2 4 7 28859 19
152653 51304 Permitted Site 7 Ceratonia siliqua :: Carob 5 4331 23rd St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 02/24/2011 12:00:00 AM   3x3 Permit Number 767250 6001037.11613846 2102279.06351254 37.7525160532628 -122.439302719451 (37.7525160532628, -122.439302719451) 2 4 5 28862 22
153705 51299 DPW Maintained 1 Ceratonia siliqua :: Carob 5 300X Golden Gate Ave 2 Sidewalk: Curb side : Cutout Tree Private 2 FUF 09/07/2004 12:00:00 AM 10   Permit Number 47670 6008033.00976 2112757.64367 37.7816834187084 -122.415851598691 (37.7816834187084, -122.415851598691) 7 10 9 28852 36
154349 60691 Permitted Site 7 Ceratonia siliqua :: Carob 5 2767 22nd St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 03/05/1983 12:00:00 AM     Permit Number 20334 6009604.72609902 2103338.10407704 37.7559077723841 -122.409749093146 (37.7559077723841, -122.409749093146) 2 4 7 28859 19
154770 47240 DPW Maintained 1 Ceratonia siliqua :: Carob 5 1006X Jamestown Ave 2 Sidewalk: Curb side : Cutout Tree Private 2 FUF 05/09/2002 12:00:00 AM 8 3x3 Permit Number 45190 6013969.3769 2089681.5637 37.7186533627648 -122.393698770823 (37.7186533627648, -122.393698770823) 10 3 8 58 1
159417 57469 Permitted Site 7 Ceratonia siliqua :: Carob 5 71 Cerritos Ave 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 12/08/1987 12:00:00 AM     Permit Number 24965 5992451.26080169 2092911.00734917 37.7263014049972 -122.468312338233 (37.7263014049972, -122.468312338233) 9 8 4 59 40
161147 60694 Permitted Site 7 Ceratonia siliqua :: Carob 5 2770 22nd St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 03/05/1983 12:00:00 AM     Permit Number 20337 6009580.52702931 2103388.84293588 37.7560457337564 -122.409836363248 (37.7560457337564, -122.409836363248) 2 4 7 28859 19
161614 63122 Permitted Site 7 Ceratonia siliqua :: Carob 5 42 Lundy's Ln 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 08/26/1993 12:00:00 AM     Permit Number 32290 6007020.23858667 2099330.24637666 37.7447579331798 -122.418402950875 (37.7447579331798, -122.418402950875) 2 7 7 28859 2
162327 60271 Permitted Site 7 Ceratonia siliqua :: Carob 5 2761 21st St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 09/10/1982 12:00:00 AM 12 3x3 Permit Number 19827 6009603.81924648 2103922.02713572 37.7575110429284 -122.409793445145 (37.7575110429284, -122.409793445145) 2 4 7 28859 19
163554 63121 Permitted Site 7 Ceratonia siliqua :: Carob 5 42 Prospect Ave 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 12/09/1986 12:00:00 AM     Permit Number 23632 6007120.53987433 2099276.08223849 37.7446148564174 -122.418052288309 (37.7446148564174, -122.418052288309) 2 7 7 28859 2
166428 65950 Permitted Site 7 Ceratonia siliqua :: Carob 5 120 Hyde St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 06/04/1990 12:00:00 AM     Permit Number 28971 6008148.07854497 2112823.994523 37.7818720705068 -122.415458212735 (37.7818720705068, -122.415458212735) 7 10 9 28852 36
167516 51302 DPW Maintained 1 Ceratonia siliqua :: Carob 5 300X Golden Gate Ave 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 09/07/2004 12:00:00 AM 12   Permit Number 47670 6008052.8861 2112760.32075 37.7816918867218 -122.415783025366 (37.7816918867218, -122.415783025366) 7 10 9 28852 36
172639 56842 Permitted Site 7 Ceratonia siliqua :: Carob 5 910 Clayton St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 04/29/1992 12:00:00 AM 3   Permit Number 30536 5998759.08975741 2106864.1829233 37.7649757529568 -122.447510501506 (37.7649757529568, -122.447510501506) 15 5 11 29492 9
172971 96123 Permitted Site 7 Ceratonia siliqua :: Carob 5 181 College Ave 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 09/08/2011 12:00:00 AM   3x3 Permit Number 767774 6004920.8 2095965.5 37.7354006937902 -122.425423007406 (37.7354006937902, -122.425423007406) 2 7 5 28861 2
177221 61796 Permitted Site 7 Ceratonia siliqua :: Carob 5 60 Pierce St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 05/25/1985 12:00:00 AM     Permit Number 21819 6002883.06164476 2108748.24537279 37.7703837393735 -122.433381373664 (37.7703837393735, -122.433381373664) 15 5 5 29492 9
180926 63125 Permitted Site 7 Ceratonia siliqua :: Carob 5 80 Prospect Ave 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 12/09/1986 12:00:00 AM     Permit Number 23639 6007006.19001516 2099063.67894521 37.744025207978 -122.418432630519 (37.744025207978, -122.418432630519) 2 7 7 28859 2
181866 68375 Permitted Site 7 Ceratonia siliqua :: Carob 5 175 Alma St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 08/09/1993 12:00:00 AM     Permit Number 32198 5997884.42699251 2106160.35589629 37.7629931985038 -122.45048498279 (37.7629931985038, -122.45048498279) 15 5 11 29492 9
183488 63120 Permitted Site 7 Ceratonia siliqua :: Carob 5 46 Lundy's Ln 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 12/09/1986 12:00:00 AM     Permit Number 23631 6007008.06371762 2099307.94192573 37.7446960047915 -122.418443468102 (37.7446960047915, -122.418443468102) 2 7 7 28859 2
190680 63270 Permitted Site 7 Ceratonia siliqua :: Carob 5 15 Winfield St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 01/26/1987 12:00:00 AM     Permit Number 23827 6007494.42657363 2099465.13084364 37.7451549781049 -122.41677284932 (37.7451549781049, -122.41677284932) 2 7 7 28859 2
192516 60263 Permitted Site 7 Ceratonia siliqua :: Carob 5 2781 21st St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 09/15/1984 12:00:00 AM     Permit Number 19819 6009497.44754454 2103916.17692673 37.7574890178355 -122.410160909746 (37.7574890178355, -122.410160909746) 2 4 7 28859 19

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