856 rows where qSpecies_id = 5 sorted by PlotSize

View and edit SQL

Fire Prevention Districts

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
6002 65883 DPW Maintained 1 Ceratonia siliqua :: Carob 5 3100X Fillmore St 1 Sidewalk: Curb side : Cutout Tree Private 2   04/23/2013 12:00:00 AM 3   Permit Number 770126 6002440.42815 2118878.88214 37.7981747762893 -122.435637321312 (37.7981747762893, -122.435637321312) 13 9 1 57 17
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
9140 48531 Permitted Site 7 Ceratonia siliqua :: Carob 5 500(REVISED) Capp St 1 Sidewalk: Curb side : Cutout Tree Private 2   08/22/2002 12:00:00 AM     Permit Number 45857 6007225.9541014 2104383.62172477 37.7586449307205 -122.41804980128 (37.7586449307205, -122.41804980128) 2 4 7 28859 19
9470 46514 Permitted Site 7 Ceratonia siliqua :: Carob 5 525or larger Golden Gate Ave In A 24 Box 3 Sidewalk: Curb side : Cutout Tree Private 2   03/27/2002 12:00:00 AM     Permit Number 44680 6007056.20383649 2112568.41573989 37.7811088818185 -122.419217465788 (37.7811088818185, -122.419217465788) 7 9 9 28852 36
9688 52724 DPW Maintained 1 Ceratonia siliqua :: Carob 5 160@ HOWARD Spear St 1 Sidewalk: Curb side : Cutout Tree Private 2   04/18/2006 12:00:00 AM 7   Permit Number 48777 6014638.31432 2116297.63809 37.791772555711 -122.393247977227 (37.791772555711, -122.393247977227) 12 2 9 28855 6
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
16430 119738 DPW Maintained 1 Ceratonia siliqua :: Carob 5 45 Fremont St 4 Sidewalk: Curb side : Cutout Tree Private 2     7     6013480.63892 2116044.41356 37.7910128776808 -122.397235794198 (37.7910128776808, -122.397235794198) 12 2 9 28855 6
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
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
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
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
43272 105450 Undocumented 4 Ceratonia siliqua :: Carob 5 890 Alabama St 2 Sidewalk: Curb side : Cutout Tree Private 2           6009082.7 2103985.1 37.7576550089679 -122.411600148106 (37.7576550089679, -122.411600148106) 2 4 7 28859 19
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
50010 85052 Permitted Site 7 Ceratonia siliqua :: Carob 5 355x Page St 2 Sidewalk: Curb side : Cutout Tree Rec/Park 5   06/27/2007 12:00:00 AM     Permit Number 49332 6004826.8 2109751.4 37.7732482408903 -122.426729425627 (37.7732482408903, -122.426729425627) 7 9 11 28852 10
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
54428 50386 Permitted Site 7 Ceratonia siliqua :: Carob 5 296 Liberty St 5 Sidewalk: Curb side : Cutout Tree Private 2   10/01/2003 12:00:00 AM     Permit Number 47041 6004379.7762802 2103977.8532584 37.7573701836913 -122.427864268021 (37.7573701836913, -122.427864268021) 2 4 5 28862 3
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
60751 64436 DPW Maintained 1 Ceratonia siliqua :: Carob 5 2445 Larkin St 1 Sidewalk: Curb side : Cutout Tree Private 2   05/16/1988 12:00:00 AM 12   Permit Number 25292 6006658.75135 2119650.10198 37.8005310432266 -122.421095439396 (37.8005310432266, -122.421095439396) 5 9 1 28858 32
62483 119737 DPW Maintained 1 Ceratonia siliqua :: Carob 5 45 Fremont St 3 Sidewalk: Curb side : Cutout Tree Private 2     7     6013490.74423 2116034.43287 37.7909860356216 -122.397200129801 (37.7909860356216, -122.397200129801) 12 2 9 28855 6
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
62929 57320 DPW Maintained 1 Ceratonia siliqua :: Carob 5 2728 Sutter St 1 Sidewalk: Curb side : Cutout Tree Private 2   08/31/1976 12:00:00 AM 15   Permit Number 16145 5999531.6355 2114001.5838 37.7846173544843 -122.445351698652 (37.7846173544843, -122.445351698652) 15 6 1 29490 31
63547 57317 DPW Maintained 1 Ceratonia siliqua :: Carob 5 2706 Sutter St 1 Sidewalk: Curb side : Cutout Tree Private 2   08/31/1976 12:00:00 AM 13   Permit Number 16141 5999606.4685 2114016.4513 37.7846624482509 -122.445093871748 (37.7846624482509, -122.445093871748) 15 6 1 29490 31
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
67860 57316 DPW Maintained 1 Ceratonia siliqua :: Carob 5 1515 Lyon St 1 Sidewalk: Curb side : Cutout Tree Private 2   08/31/1976 12:00:00 AM 13   Permit Number 16140 5999629.2653 2114178.0114 37.7851073514303 -122.445026621162 (37.7851073514303, -122.445026621162) 15 6 1 29490 31
69517 48533 Permitted Site 7 Ceratonia siliqua :: Carob 5 500(REVISED) Capp St 3 Sidewalk: Curb side : Cutout Tree Private 2   08/22/2002 12:00:00 AM     Permit Number 45857 6007225.9541014 2104383.62172477 37.7586449307205 -122.41804980128 (37.7586449307205, -122.41804980128) 2 4 7 28859 19
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
71727 65411 Permitted Site 7 Ceratonia siliqua :: Carob 5 81 Webster St 1 Sidewalk: Curb side : Cutout Tree Private 2   11/16/1989 12:00:00 AM     Permit Number 28262 6004263.16526256 2108931.19399052 37.7709642723528 -122.428620636268 (37.7709642723528, -122.428620636268) 7 9 11 29492 10
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
86582 105449 Undocumented 4 Ceratonia siliqua :: Carob 5 890 Alabama St 1 Sidewalk: Curb side : Cutout Tree Private 2           6009082.7 2103985.1 37.7576550089679 -122.411600148106 (37.7576550089679, -122.411600148106) 2 4 7 28859 19
88181 85254 DPW Maintained 1 Ceratonia siliqua :: Carob 5 45 Fremont St 1 Sidewalk: Curb side : Cutout Tree Private 2     9   Permit Number 49553 6013520.55509 2116003.76772 37.7909034958536 -122.397094833572 (37.7909034958536, -122.397094833572) 12 2 9 28855 6
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
93710 40183 DPW Maintained 1 Ceratonia siliqua :: Carob 5 298X Missouri St 1 Sidewalk: Curb side : Cutout Tree Private 2   04/27/1999 12:00:00 AM 11   Permit Number 41371 6013446.24914 2105734.66956 37.7627027466551 -122.39663174926 (37.7627027466551, -122.39663174926) 14 3 8 28856 29
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
99119 50383 Permitted Site 7 Ceratonia siliqua :: Carob 5 296 Liberty St 2 Sidewalk: Curb side : Cutout Tree Private 2   10/01/2003 12:00:00 AM     Permit Number 47041 6004379.7762802 2103977.8532584 37.7573701836913 -122.427864268021 (37.7573701836913, -122.427864268021) 2 4 5 28862 3
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
103441 50384 Permitted Site 7 Ceratonia siliqua :: Carob 5 296 Liberty St 7 Sidewalk: Curb side : Cutout Tree Private 2   10/01/2003 12:00:00 AM     Permit Number 47041 6004379.7762802 2103977.8532584 37.7573701836913 -122.427864268021 (37.7573701836913, -122.427864268021) 2 4 5 28862 3
107461 85255 DPW Maintained 1 Ceratonia siliqua :: Carob 5 45 Fremont St 2 Sidewalk: Curb side : Cutout Tree Private 2     6   Permit Number 49553 6013503.0525 2116024.16318 37.7909585226636 -122.39715682295 (37.7909585226636, -122.39715682295) 12 2 9 28855 6
110285 32421 DPW Maintained 1 Ceratonia siliqua :: Carob 5 400 Sussex St 1 Sidewalk: Curb side : Cutout Tree Private 2   10/08/1996 12:00:00 AM 12   Permit Number 36948 6000917.26502 2096711.23126 37.7372212865363 -122.439318125938 (37.7372212865363, -122.439318125938) 2 7 5 63 7
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
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
113085 58721 Permitted Site 7 Ceratonia siliqua :: Carob 5 66 Carmelita St 1 Sidewalk: Curb side : Cutout Tree Private 2   03/16/1981 12:00:00 AM     Permit Number 19065 6002629.53182761 2108749.25499909 37.7703721248343 -122.434258404788 (37.7703721248343, -122.434258404788) 15 5 5 29492 9
114865 201371 DPW Maintained 1 Ceratonia siliqua :: Carob 5 1 Hare St 1 Sidewalk: Curb side : Yard Tree Private 2     12     6018297.03999 2095334.93444 37.7344159629251 -122.379132069983 (37.7344159629251, -122.379132069983) 10 3 8 58 1
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
122812 23566 DPW Maintained 1 Ceratonia siliqua :: Carob 5 2958 Van Ness Ave 2 Sidewalk: Curb side : Cutout Tree Private 2   06/09/2005 12:00:00 AM 6     6005632.06356 2120580.68582 37.8030282582004 -122.424714436346 (37.8030282582004, -122.424714436346) 5 9 1 28858 32
123100 56925 DPW Maintained 1 Ceratonia siliqua :: Carob 5 120 Howard St 1 Sidewalk: Curb side : Cutout Tree Private 2   08/15/1974 12:00:00 AM 12   Permit Number 14168 6014784.53223 2116103.90747 37.7912487383869 -122.392728500917 (37.7912487383869, -122.392728500917) 12 2 9 28855 6
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
128316 206000 DPW Maintained 1 Ceratonia siliqua :: Carob 5 419 Flood Ave 3 Sidewalk: Property side : Yard Tree Private 2     7     5997987.32263 2094070.28162 37.7298026971396 -122.449258019538 (37.7298026971396, -122.449258019538) 9 7 4 28861 40
129067 51546 Permitted Site 7 Ceratonia siliqua :: Carob 5 655 Beach St 1 Sidewalk: Curb side : Cutout Tree Private 2   02/01/2005 12:00:00 AM     Permit Number 47845 6007074.31830792 2121880.33708987 37.8066781199827 -122.419815746942 (37.8066781199827, -122.419815746942) 5 1 1 28858 32
130611 50385 Permitted Site 7 Ceratonia siliqua :: Carob 5 296 Liberty St 6 Sidewalk: Curb side : Cutout Tree Private 2   10/01/2003 12:00:00 AM     Permit Number 47041 6004379.7762802 2103977.8532584 37.7573701836913 -122.427864268021 (37.7573701836913, -122.427864268021) 2 4 5 28862 3
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
131544 59362 Permitted Site 7 Ceratonia siliqua :: Carob 5 300 Sussex St 1 Sidewalk: Curb side : Cutout Tree Private 2   11/21/1980 12:00:00 AM     Permit Number 18713 6001270.92113106 2096540.31776103 37.7367721171555 -122.4380831379 (37.7367721171555, -122.4380831379) 2 7 5 63 7
131762 50388 Permitted Site 7 Ceratonia siliqua :: Carob 5 296 Liberty St 3 Sidewalk: Curb side : Cutout Tree Private 2   10/01/2003 12:00:00 AM     Permit Number 47041 6004379.7762802 2103977.8532584 37.7573701836913 -122.427864268021 (37.7573701836913, -122.427864268021) 2 4 5 28862 3
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
138479 85051 Permitted Site 7 Ceratonia siliqua :: Carob 5 355x Page St 1 Sidewalk: Curb side : Cutout Tree Rec/Park 5   06/27/2007 12:00:00 AM     Permit Number 49332 6004826.8 2109751.4 37.7732482408903 -122.426729425627 (37.7732482408903, -122.426729425627) 7 9 11 28852 10
139674 101042 Permitted Site 7 Ceratonia siliqua :: Carob 5 655 Beach St 2 Sidewalk: Curb side : Cutout Tree Private 2         Permit Number 47845 6006837 2121873 37.8066446021589 -122.420636512845 (37.8066446021589, -122.420636512845) 5 1 1 28858 32
140204 201373 DPW Maintained 1 Ceratonia siliqua :: Carob 5 2 Hare St 1 Sidewalk: Property side : Yard Tree Private 2     9     6018334.73237 2095383.10991 37.7345503216464 -122.379005098324 (37.7345503216464, -122.379005098324) 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
145716 101044 Permitted Site 7 Ceratonia siliqua :: Carob 5 655 Beach St 4 Sidewalk: Curb side : Cutout Tree Private 2         Permit Number 47845 6006837 2121873 37.8066446021589 -122.420636512845 (37.8066446021589, -122.420636512845) 5 1 1 28858 32
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
156383 30908 DPW Maintained 1 Ceratonia siliqua :: Carob 5 1511 Lyon St 1 Sidewalk: Curb side : Cutout Tree Private 2   03/13/1995 12:00:00 AM 7   Permit Number 34730 5999634.2212 2114153.2322 37.7850395970423 -122.445007693392 (37.7850395970423, -122.445007693392) 15 6 1 29490 31
156506 101043 Permitted Site 7 Ceratonia siliqua :: Carob 5 655 Beach St 3 Sidewalk: Curb side : Cutout Tree Private 2         Permit Number 47845 6006837 2121873 37.8066446021589 -122.420636512845 (37.8066446021589, -122.420636512845) 5 1 1 28858 32
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
161042 101045 Permitted Site 7 Ceratonia siliqua :: Carob 5 655 Beach St 5 Sidewalk: Curb side : Cutout Tree Private 2         Permit Number 47845 6006837 2121873 37.8066446021589 -122.420636512845 (37.8066446021589, -122.420636512845) 5 1 1 28858 32
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
161298 47317 Permitted Site 7 Ceratonia siliqua :: Carob 5 2524 19th St 2 Sidewalk: Curb side : Cutout Tree Private 2   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
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
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
164599 51670 Permitted Site 7 Ceratonia siliqua :: Carob 5 848 Clayton St 1 Sidewalk: Curb side : Cutout Tree Private 2         Permit Number 47948 5998713.82301338 2107188.47532501 37.765863591183 -122.447690414133 (37.765863591183, -122.447690414133) 15 5 11 29492 9
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
169962 83036 DPW Maintained 1 Ceratonia siliqua :: Carob 5 100X Cargo Way 16 Sidewalk: Curb side : Cutout Tree Port 6   03/18/2017 02:55:00 PM 3     6018559.56213 2097806.04485 37.7412156164156 -122.378395939846 (37.7412156164156, -122.378395939846) 10 3 8 58 1
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
172953 34010 Permitted Site 7 Ceratonia siliqua :: Carob 5 123 Noe St 1 Sidewalk: Curb side : Cutout Tree Private 2   04/28/1997 12:00:00 AM     Permit Number 37945 6002886.66979468 2107551.69377695 37.7670985064042 -122.433283380019 (37.7670985064042, -122.433283380019) 15 5 5 28862 3
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
177869 33711 Permitted Site 7 Ceratonia siliqua :: Carob 5 109 Germania St 1 Sidewalk: Curb side : Cutout Tree Private 2   12/04/1996 12:00:00 AM     Permit Number 37779 6003691.57039211 2108804.29883955 37.7705834843276 -122.430588742236 (37.7705834843276, -122.430588742236) 15 9 11 29492 10
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

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