trees
856 rows where qSpecies_id = 5 sorted by qCareAssistant descending
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) |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
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 | ||
7794 | 78331 | DPW Maintained 1 | Ceratonia siliqua :: Carob 5 | 50 Pomona St | 16 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | DPW for City Agency | 3 | 3x3 | 6014103.03356 | 2094377.1679 | 37.7315539757311 | -122.393565225657 | (37.7315539757311, -122.393565225657) | 10 | 3 | 8 | 58 | 1 | ||
8094 | 78325 | DPW Maintained 1 | Ceratonia siliqua :: Carob 5 | 50 Pomona St | 22 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | DPW for City Agency | 3 | 3x3 | 6014082.07463 | 2094268.00581 | 37.7312530742586 | -122.393630047885 | (37.7312530742586, -122.393630047885) | 10 | 3 | 8 | 58 | 1 | ||
82714 | 94895 | DPW Maintained 1 | Ceratonia siliqua :: Carob 5 | 43 Flora St | 4 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | DPW for City Agency | 11/23/2010 12:00:00 AM | 3 | 3x3 | Permit Number 53954 | 6014036.5 | 2094589.2 | 37.7321324754711 | -122.393810082896 | (37.7321324754711, -122.393810082896) | 10 | 3 | 8 | 58 | 1 |
84292 | 94894 | DPW Maintained 1 | Ceratonia siliqua :: Carob 5 | 43 Flora St | 3 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | DPW for City Agency | 11/23/2010 12:00:00 AM | 3 | 3x3 | Permit Number 53954 | 6014036.5 | 2094589.2 | 37.7321324754711 | -122.393810082896 | (37.7321324754711, -122.393810082896) | 10 | 3 | 8 | 58 | 1 |
132285 | 94893 | DPW Maintained 1 | Ceratonia siliqua :: Carob 5 | 43 Flora St | 2 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | DPW for City Agency | 11/23/2010 12:00:00 AM | 3 | 3x3 | Permit Number 53954 | 6014036.5 | 2094589.2 | 37.7321324754711 | -122.393810082896 | (37.7321324754711, -122.393810082896) | 10 | 3 | 8 | 58 | 1 |
167565 | 94892 | DPW Maintained 1 | Ceratonia siliqua :: Carob 5 | 43 Flora St | 1 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | DPW for City Agency | 11/23/2010 12:00:00 AM | 3 | 3x3 | Permit Number 53954 | 6014036.5 | 2094589.2 | 37.7321324754711 | -122.393810082896 | (37.7321324754711, -122.393810082896) | 10 | 3 | 8 | 58 | 1 |
7 | 188479 | Prune Opt Out 3 | Ceratonia siliqua :: Carob 5 | 2208 Mariposa St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 3ft | Permit Number 787847 | 6010817.79084 | 2106032.71885 | 37.7633744862602 | -122.405743691032 | (37.7633744862602, -122.405743691032) | 8 | 4 | 8 | 28859 | 19 | ||
239 | 205987 | DPW Maintained 1 | Ceratonia siliqua :: Carob 5 | 1639 17th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 3ft | 5990866.8027 | 2104246.93654 | 37.7573353075836 | -122.474616638541 | (37.7573353075836, -122.474616638541) | 1 | 8 | 4 | 56 | 12 | |||
372 | 189871 | DPW Maintained 1 | Ceratonia siliqua :: Carob 5 | 400 Newhall St | 9 | : | Tree | Private 2 | 7 | Width 3ft | 6016028.58203 | 2097927.48174 | 37.7414092251604 | -122.387155715173 | (37.7414092251604, -122.387155715173) | 10 | 3 | 8 | 58 | 1 | |||
438 | 16548 | Permitted Site 7 | Ceratonia siliqua :: Carob 5 | 400X Newhall St | 9 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | 3x3 | 6016043.45751 | 2097947.55726 | 37.7414651721818 | -122.387105680372 | (37.7414651721818, -122.387105680372) | 10 | 3 | 8 | 58 | 1 | |||
640 | 222906 | DPW Maintained 1 | Ceratonia siliqua :: Carob 5 | 363 Page St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 4ft | 6004761.72453 | 2109824.22026 | 37.7734445081828 | -122.42695971791 | (37.7734445081828, -122.42695971791) | 7 | 9 | 11 | 28852 | 10 | |||
846 | 115842 | DPW Maintained 1 | Ceratonia siliqua :: Carob 5 | 1500 Bay St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | 3x3 | 6003573.21553 | 2120746.37029 | 37.8033666892713 | -122.431850957862 | (37.8033666892713, -122.431850957862) | 13 | 9 | 1 | 57 | 17 | |||
857 | 189910 | DPW Maintained 1 | Ceratonia siliqua :: Carob 5 | 350 Newhall St | 11 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 14 | Width 3ft | 6016250.22154 | 2098227.10108 | 37.7422441899167 | -122.386410241063 | (37.7422441899167, -122.386410241063) | 10 | 3 | 8 | 58 | 1 | |||
1256 | 97187 | Undocumented 4 | Ceratonia siliqua :: Carob 5 | 10X Fremont St | 9 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | 3x3 | 6013222.5 | 2116242.1 | 37.7915413037038 | -122.398142826086 | (37.7915413037038, -122.398142826086) | 12 | 2 | 9 | 28855 | 6 | |||
1800 | 189943 | DPW Maintained 1 | Ceratonia siliqua :: Carob 5 | 160 Spear St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 3ft | 6014663.90287 | 2116268.03372 | 37.7916926905231 | -122.393157367813 | (37.7916926905231, -122.393157367813) | 12 | 2 | 9 | 28855 | 6 | |||
1856 | 16547 | DPW Maintained 1 | Ceratonia siliqua :: Carob 5 | 400X Newhall St | 8 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | 3x3 | 6016044.76119 | 2097949.4335 | 37.7414703961451 | -122.387101303489 | (37.7414703961451, -122.387101303489) | 10 | 3 | 8 | 58 | 1 | |||
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 | |||
2472 | 6651 | DPW Maintained 1 | Ceratonia siliqua :: Carob 5 | 495X Newhall St | 7 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 18 | 3x3 | 6016063.3688156 | 2097887.7750356 | 37.7413021249823 | -122.38703266472 | (37.7413021249823, -122.38703266472) | 10 | 3 | 8 | 58 | 1 | |||
3395 | 17446 | DPW Maintained 1 | Ceratonia siliqua :: Carob 5 | 1966 Palou Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 3x3 | 6012949.46477 | 2096727.20845 | 37.7379425338291 | -122.397718137505 | (37.7379425338291, -122.397718137505) | 10 | 3 | 8 | 58 | 1 | |||
3688 | 189905 | DPW Maintained 1 | Ceratonia siliqua :: Carob 5 | 350 Newhall St | 6 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | Width 3ft | 6016340.3864 | 2098339.29531 | 37.7425572430226 | -122.386106295385 | (37.7425572430226, -122.386106295385) | 10 | 3 | 8 | 58 | 1 | |||
4441 | 246422 | DPW Maintained 1 | Ceratonia siliqua :: Carob 5 | 400 Duncan St | 4 | Sidewalk: Curb side : Yard | Tree | Private 2 | 9 | Width 4ft | 6003829.35465 | 2099854.81871 | 37.7460181445246 | -122.429473817668 | (37.7460181445246, -122.429473817668) | 2 | 7 | 5 | 63 | 22 | |||
5594 | 106035 | Permitted Site 7 | Ceratonia siliqua :: Carob 5 | 195X Main St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6014366.74772 | 2116104.57878 | 37.7912273690908 | -122.394174082061 | (37.7912273690908, -122.394174082061) | 12 | 2 | 9 | 28855 | 6 | ||||
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 | |||
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 | ||
6377 | 82142 | Permitted Site 7 | Ceratonia siliqua :: Carob 5 | 30 Molimo Dr | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/25/2007 12:00:00 AM | 3x3 | Permit Number 49838 | 5998889.06181671 | 2096571.98929044 | 37.736723332936 | -122.446320512355 | (37.736723332936, -122.446320512355) | 9 | 7 | 4 | 59 | 40 | ||
6962 | 189948 | DPW Maintained 1 | Ceratonia siliqua :: Carob 5 | 162 Spear St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 1ft | 6014781.22378 | 2116142.62721 | 37.7913548700732 | -122.392742658052 | (37.7913548700732, -122.392742658052) | 12 | 2 | 9 | 28855 | 6 | |||
8003 | 21791 | Permitted Site 7 | Ceratonia siliqua :: Carob 5 | 2585 Taylor St | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | 4X4 | 6008347.28278 | 2121527.17705 | 37.8057800612465 | -122.415385378175 | (37.8057800612465, -122.415385378175) | 5 | 1 | 10 | 308 | 23 | |||
8125 | 189865 | DPW Maintained 1 | Ceratonia siliqua :: Carob 5 | 501 Newhall St | 2 | : | Tree | Private 2 | 13 | Width 4ft | 6015985.7864 | 2097784.98338 | 37.7410155838051 | -122.387293751216 | (37.7410155838051, -122.387293751216) | 10 | 3 | 8 | 58 | 1 | |||
8477 | 224897 | DPW Maintained 1 | Ceratonia siliqua :: Carob 5 | 600 Eugenia Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 3ft | 6007276.43224 | 2097752.07019 | 37.7404390320343 | -122.417405258456 | (37.7404390320343, -122.417405258456) | 2 | 7 | 7 | 28859 | 2 |
Advanced export
JSON shape: default, array, newline-delimited, object
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) );