trees
856 rows where qSpecies_id = 5 sorted by DBH
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) |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
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 | ||||
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 | ||
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 | |||
13958 | 262096 | DPW Maintained 1 | Ceratonia siliqua :: Carob 5 | 350 Newhall St | 3 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | Width 3ft | 6016433.67399 | 2098382.99048 | 37.7426823836985 | -122.385786776164 | (37.7426823836985, -122.385786776164) | 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 | ||
29632 | 102874 | Permitted Site 7 | Ceratonia siliqua :: Carob 5 | 2761 21st St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4x4 | 6009574.6 | 2103896.5 | 37.7574393136514 | -122.409892695521 | (37.7574393136514, -122.409892695521) | 2 | 4 | 7 | 28859 | 19 | ||||
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 | ||
36090 | 58566 | Permitted Site 7 | Ceratonia siliqua :: Carob 5 | 119 Carl St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 04/16/1979 12:00:00 AM | 3x3 | Permit Number 17756 | 5997901.33257876 | 2107130.89979942 | 37.7656590338964 | -122.450496484092 | (37.7656590338964, -122.450496484092) | 15 | 5 | 11 | 29492 | 9 | ||
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 | ||
37802 | 119741 | Undocumented 4 | Ceratonia siliqua :: Carob 5 | 15X Fremont St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6013411 | 2116073 | 37.7910874921548 | -122.39747874957 | (37.7910874921548, -122.39747874957) | 12 | 2 | 9 | 28855 | 6 | ||||
37929 | 82121 | Permitted Site 7 | Ceratonia siliqua :: Carob 5 | 44 Molimo Dr | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/25/2007 12:00:00 AM | 3x3 | Permit Number 49840 | 5998809.17063994 | 2096527.78133102 | 37.7365973852663 | -122.446593550118 | (37.7365973852663, -122.446593550118) | 9 | 7 | 4 | 59 | 40 | ||
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 | ||
41358 | 115360 | Undocumented 4 | Ceratonia siliqua :: Carob 5 | 205 ARKANSAS ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x4 | 6012944 | 2106057 | 37.7635598294353 | -122.398391479388 | (37.7635598294353, -122.398391479388) | 14 | 3 | 8 | 28856 | 29 | ||||
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 | ||
44569 | 119744 | Undocumented 4 | Ceratonia siliqua :: Carob 5 | 15X Fremont St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6013411 | 2116073 | 37.7910874921548 | -122.39747874957 | (37.7910874921548, -122.39747874957) | 12 | 2 | 9 | 28855 | 6 | ||||
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 | ||
52265 | 95955 | Permitted Site 7 | Ceratonia siliqua :: Carob 5 | 190X Spear St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 03/18/2011 12:00:00 AM | 3x3 | Permit Number 767637 | 6014675 | 2116143.7 | 37.791351915434 | -122.393110267966 | (37.791351915434, -122.393110267966) | 12 | 2 | 9 | 28855 | 6 | ||
53679 | 56848 | Permitted Site 7 | Ceratonia siliqua :: Carob 5 | 1025 Clayton St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 08/02/1974 12:00:00 AM | 6x5 | Permit Number 14082 | 5998817.86133668 | 2106377.94605096 | 37.7636440271414 | -122.447272227776 | (37.7636440271414, -122.447272227776) | 15 | 5 | 11 | 29492 | 9 | ||
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 | |||
54786 | 106031 | Permitted Site 7 | Ceratonia siliqua :: Carob 5 | 180 Howard St | 7 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6014640.7 | 2115990 | 37.7909279854042 | -122.39321818634 | (37.7909279854042, -122.39321818634) | 12 | 2 | 9 | 28855 | 6 | ||||
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 | ||
61904 | 110184 | Undocumented 4 | Ceratonia siliqua :: Carob 5 | 1500x LYON ST | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 5999718 | 2114083 | 37.7848515388794 | -122.444712796347 | (37.7848515388794, -122.444712796347) | 15 | 6 | 1 | 29490 | 31 | ||||
62148 | 115558 | Undocumented 4 | Ceratonia siliqua :: Carob 5 | 2500x 19TH ST | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6010357 | 2105131 | 37.7608727909959 | -122.407273854716 | (37.7608727909959, -122.407273854716) | 10 | 4 | 8 | 28859 | 19 | ||||
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 | ||
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 | ||
70907 | 102876 | Permitted Site 7 | Ceratonia siliqua :: Carob 5 | 2761 21st St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6009574.6 | 2103896.5 | 37.7574393136514 | -122.409892695521 | (37.7574393136514, -122.409892695521) | 2 | 4 | 7 | 28859 | 19 | ||||
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 | ||
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 | ||
82931 | 110183 | Undocumented 4 | Ceratonia siliqua :: Carob 5 | 1500x LYON ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 5999718 | 2114083 | 37.7848515388794 | -122.444712796347 | (37.7848515388794, -122.444712796347) | 15 | 6 | 1 | 29490 | 31 | ||||
82972 | 110185 | Undocumented 4 | Ceratonia siliqua :: Carob 5 | 1500x LYON ST | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 5999718 | 2114083 | 37.7848515388794 | -122.444712796347 | (37.7848515388794, -122.444712796347) | 15 | 6 | 1 | 29490 | 31 | ||||
85587 | 94581 | Permitted Site 7 | Ceratonia siliqua :: Carob 5 | 1025 Clayton St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4x4 | 5998825 | 2106371 | 37.763625362932 | -122.447247037522 | (37.763625362932, -122.447247037522) | 15 | 5 | 11 | 29492 | 9 | ||||
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 | |||||
89068 | 119742 | Undocumented 4 | Ceratonia siliqua :: Carob 5 | 15X Fremont St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6013411 | 2116073 | 37.7910874921548 | -122.39747874957 | (37.7910874921548, -122.39747874957) | 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 | ||
94151 | 87254 | Permitted Site 7 | Ceratonia siliqua :: Carob 5 | 32 McCarthy Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | Permit Number 50278 | 6007985.7 | 2086740.5 | 37.7102434920179 | -122.414174016703 | (37.7102434920179, -122.414174016703) | 9 | 7 | 8 | 309 | 39 | |||
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 | ||
97684 | 115557 | Undocumented 4 | Ceratonia siliqua :: Carob 5 | 2500x 19TH ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6010357 | 2105131 | 37.7608727909959 | -122.407273854716 | (37.7608727909959, -122.407273854716) | 10 | 4 | 8 | 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 | |||
100997 | 173732 | DPW Maintained 1 | Ceratonia siliqua :: Carob 5 | 1690x Galvez Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6015419 | 2098106 | 37.7418656239974 | -122.389275919147 | (37.7418656239974, -122.389275919147) | 10 | 3 | 8 | 58 | 1 | ||||
101550 | 119745 | Undocumented 4 | Ceratonia siliqua :: Carob 5 | 15X Fremont St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6013411 | 2116073 | 37.7910874921548 | -122.39747874957 | (37.7910874921548, -122.39747874957) | 12 | 2 | 9 | 28855 | 6 | ||||
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 | |||
105981 | 106036 | Permitted Site 7 | Ceratonia siliqua :: Carob 5 | 195X Main St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 02/05/2015 12:00:00 AM | 3x3 | Permit Number 770222 | 6014366.74772 | 2116104.57878 | 37.7912273690908 | -122.394174082061 | (37.7912273690908, -122.394174082061) | 12 | 2 | 9 | 28855 | 6 | ||
107743 | 54886 | Permitted Site 7 | Ceratonia siliqua :: Carob 5 | 140 Carl St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 08/16/1972 12:00:00 AM | 3x4 | Permit Number 10751 | 5997750.13061777 | 2107162.33224107 | 37.7657366841835 | -122.451021722872 | (37.7657366841835, -122.451021722872) | 15 | 5 | 11 | 29492 | 9 | ||
112170 | 56845 | Permitted Site 7 | Ceratonia siliqua :: Carob 5 | 980 Clayton St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 08/02/1974 12:00:00 AM | 4x4 | Permit Number 14078 | 5998833.42862215 | 2106621.08669964 | 37.7643125198309 | -122.447235885769 | (37.7643125198309, -122.447235885769) | 15 | 5 | 11 | 29492 | 9 | ||
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 | |||
115939 | 82092 | Permitted Site 7 | Ceratonia siliqua :: Carob 5 | 30 Molimo Dr | 4 | 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 | ||
117938 | 105930 | Undocumented 4 | Ceratonia siliqua :: Carob 5 | 971 Florida St | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6009455 | 2103552.4 | 37.7564877890416 | -122.410282026926 | (37.7564877890416, -122.410282026926) | 2 | 4 | 7 | 28859 | 19 | |||||
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 | ||
124822 | 111888 | Undocumented 4 | Ceratonia siliqua :: Carob 5 | 140 LUNDYS LN | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x12 | 6006709 | 2098750 | 37.7431471814186 | -122.41943799965 | (37.7431471814186, -122.41943799965) | 2 | 7 | 7 | 28859 | 2 | ||||
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 | |||
133859 | 87253 | Permitted Site 7 | Ceratonia siliqua :: Carob 5 | 2 McCarthy Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | Permit Number 50277 | 6008031.4 | 2086860.8 | 37.7105763778259 | -122.414024572568 | (37.7105763778259, -122.414024572568) | 9 | 7 | 8 | 309 | 39 | |||
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 | ||||
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 | ||||
146949 | 82141 | Permitted Site 7 | Ceratonia siliqua :: Carob 5 | 30 Molimo Dr | 3 | 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 | ||
147008 | 106033 | Permitted Site 7 | Ceratonia siliqua :: Carob 5 | 195X Main St | 2 | 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 | ||||
149041 | 113693 | Undocumented 4 | Ceratonia siliqua :: Carob 5 | 112 LUNDYS LN | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x5 | 6006814 | 2098928 | 37.7436418429474 | -122.419087559811 | (37.7436418429474, -122.419087559811) | 2 | 7 | 7 | 28859 | 2 | ||||
150580 | 82143 | Permitted Site 7 | Ceratonia siliqua :: Carob 5 | 30 Molimo Dr | 1 | 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 | ||
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 | |
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 | ||
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 | ||
163468 | 119743 | Undocumented 4 | Ceratonia siliqua :: Carob 5 | 15X Fremont St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6013411 | 2116073 | 37.7910874921548 | -122.39747874957 | (37.7910874921548, -122.39747874957) | 12 | 2 | 9 | 28855 | 6 |
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) );