trees
339 rows where qSpecies_id = 30 sorted by rowid 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) |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
193830 | 221480 | DPW Maintained 1 | Acacia stenophylla :: Shoestring Acacia 30 | 400x Guerrero St | 13 | Median : Cutout | Tree | DPW 1 | 04/29/2015 05:03:00 AM | 1 | Width 3ft | 6005548.13055 | 2106148.77804 | 37.7633970583515 | -122.423978006683 | (37.7633970583515, -122.423978006683) | 8 | 4 | 5 | 28859 | 19 | ||
193458 | 110773 | DPW Maintained 1 | Acacia stenophylla :: Shoestring Acacia 30 | 1000X GUERRERO ST | 2 | Median : Cutout | Tree | DPW 1 | 05/26/2015 03:06:00 PM | 3 | 3x3 | 6005663 | 2103080 | 37.7549773975701 | -122.423362541701 | (37.7549773975701, -122.423362541701) | 2 | 4 | 5 | 28859 | 19 | ||
193332 | 66265 | Permitted Site 7 | Acacia stenophylla :: Shoestring Acacia 30 | 4020 26th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/30/1990 12:00:00 AM | 3 | 6x9 | Permit Number 29370 | 6003740.3803829 | 2100725.5739603 | 37.7484039979455 | -122.429843577344 | (37.7484039979455, -122.429843577344) | 2 | 4 | 5 | 28862 | 22 | |
192188 | 221509 | DPW Maintained 1 | Acacia stenophylla :: Shoestring Acacia 30 | 1201 San Jose Ave | 38 | Front Yard : Yard | Tree | Private 2 | 2 | 6004439.44088 | 2096038.01178 | 37.7355725864019 | -122.427092409311 | (37.7355725864019, -122.427092409311) | 2 | 7 | 5 | 28861 | 2 | ||||
191935 | 91240 | DPW Maintained 1 | Acacia stenophylla :: Shoestring Acacia 30 | 842x Guerrero St | 2 | Median : Cutout | Tree | DPW 1 | 11/20/2009 12:00:00 AM | 3 | 6005622 | 2104059 | 37.7576631893365 | -122.423573931211 | (37.7576631893365, -122.423573931211) | 2 | 4 | 5 | 28859 | 19 | |||
191122 | 221533 | DPW Maintained 1 | Acacia stenophylla :: Shoestring Acacia 30 | 1100x Guerrero St | 9 | Median : Cutout | Tree | DPW 1 | 8 | Width 3ft | 6005767.42939 | 2102227.70946 | 37.75264309841 | -122.422940823082 | (37.75264309841, -122.422940823082) | 2 | 4 | 5 | 28859 | 19 | |||
190784 | 152422 | DPW Maintained 1 | Acacia stenophylla :: Shoestring Acacia 30 | 700x Guerrero St | 11 | Median : Cutout | Tree | DPW 1 | 0 | Width 3ft | 6005644.93763 | 2104427.72747 | 37.7586769234173 | -122.423520817442 | (37.7586769234173, -122.423520817442) | 2 | 4 | 5 | 28859 | 19 | |||
190513 | 115514 | DPW Maintained 1 | Acacia stenophylla :: Shoestring Acacia 30 | 200x Guerrero St | 5 | Median : Cutout | Tree | DPW 1 | 02/09/2016 11:36:00 AM | 3 | 6005415.2 | 2107753.5 | 37.7677957371292 | -122.424551925681 | (37.7677957371292, -122.424551925681) | 8 | 4 | 5 | 28853 | 19 | |||
190176 | 184203 | DPW Maintained 1 | Acacia stenophylla :: Shoestring Acacia 30 | 1466 41st Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 0ft | 5983430.71 | 2105161.519 | 37.7594128206633 | -122.500400782356 | (37.7594128206633, -122.500400782356) | 1 | 8 | 3 | 56 | 35 | |||
189657 | 221428 | DPW Maintained 1 | Acacia stenophylla :: Shoestring Acacia 30 | 100x Guerrero St | 1 | Median : Cutout | Tree | DPW 1 | 07/15/2016 05:47:00 AM | 1 | Width 3ft | 6005427.7802 | 2108362.05998 | 37.7694674075229 | -122.424551705821 | (37.7694674075229, -122.424551705821) | 8 | 4 | 5 | 28853 | 19 | ||
187472 | 221450 | DPW Maintained 1 | Acacia stenophylla :: Shoestring Acacia 30 | 200x Guerrero St | 6 | Median : Cutout | Tree | DPW 1 | 02/09/2016 11:34:00 AM | 1 | Width 3ft | 6005469.47774 | 2107557.31332 | 37.7672601204903 | -122.424350229795 | (37.7672601204903, -122.424350229795) | 8 | 4 | 5 | 28853 | 19 | ||
187231 | 109702 | DPW Maintained 1 | Acacia stenophylla :: Shoestring Acacia 30 | 600x GUERRERO ST | 10 | Median : Cutout | Tree | DPW 1 | 02/21/2015 11:06:00 PM | 3 | 3x3 | 6005435.8 | 2105392.6 | 37.7613144297161 | -122.424312736622 | (37.7613144297161, -122.424312736622) | 2 | 4 | 5 | 28859 | 19 | ||
186954 | 221539 | DPW Maintained 1 | Acacia stenophylla :: Shoestring Acacia 30 | 1100x Guerrero St | 2 | Median : Cutout | Tree | DPW 1 | 5 | Width 3ft | 6005756.51513 | 2102435.13947 | 37.753212037416 | -122.422993308391 | (37.753212037416, -122.422993308391) | 2 | 4 | 5 | 28859 | 19 | |||
186895 | 221549 | DPW Maintained 1 | Acacia stenophylla :: Shoestring Acacia 30 | 1000x Guerrero St | 6 | Median : Cutout | Tree | DPW 1 | 1 | Width 3ft | 6005728.89674 | 2102911.59468 | 37.7545187145683 | -122.423122682192 | (37.7545187145683, -122.423122682192) | 2 | 4 | 5 | 28859 | 19 | |||
185643 | 221512 | DPW Maintained 1 | Acacia stenophylla :: Shoestring Acacia 30 | 1300x Guerrero St | 10 | Median : Cutout | Tree | DPW 1 | 7 | Width 3ft | 6005835.43443 | 2101000.02463 | 37.7492759952973 | -122.422618416129 | (37.7492759952973, -122.422618416129) | 2 | 4 | 5 | 28859 | 19 | |||
185467 | 221510 | DPW Maintained 1 | Acacia stenophylla :: Shoestring Acacia 30 | 1300x Guerrero St | 13 | Median : Cutout | Tree | DPW 1 | 7 | Width 3ft | 6005838.80296 | 2100921.02333 | 37.7490592658716 | -122.422601154533 | (37.7490592658716, -122.422601154533) | 2 | 4 | 5 | 28859 | 19 | |||
185336 | 91251 | DPW Maintained 1 | Acacia stenophylla :: Shoestring Acacia 30 | 906X Guerrero St | 1 | Median : Cutout | Tree | DPW 1 | 11/20/2008 12:00:00 AM | 3 | 3x100 | 6005675.14042 | 2103682.124768 | 37.7566313772663 | -122.423363358583 | (37.7566313772663, -122.423363358583) | 2 | 4 | 5 | 28859 | 19 | ||
182979 | 221555 | DPW Maintained 1 | Acacia stenophylla :: Shoestring Acacia 30 | 1000x Guerrero St | 13 | Median : Cutout | Tree | DPW 1 | 2 | Width 3ft | 6005738.9106 | 2102712.57542 | 37.753972818908 | -122.423073906548 | (37.753972818908, -122.423073906548) | 2 | 4 | 5 | 28859 | 19 | |||
182752 | 221536 | DPW Maintained 1 | Acacia stenophylla :: Shoestring Acacia 30 | 1100x Guerrero St | 5 | Median : Cutout | Tree | DPW 1 | 9 | Width 3ft | 6005762.1987 | 2102333.32685 | 37.7529328042098 | -122.422966417762 | (37.7529328042098, -122.422966417762) | 2 | 4 | 5 | 28859 | 19 | |||
182549 | 221521 | DPW Maintained 1 | Acacia stenophylla :: Shoestring Acacia 30 | 1200x Guerrero St | 12 | Median : Cutout | Tree | DPW 1 | 7 | Width 3ft | 6005805.66932 | 2101529.55059 | 37.7507282726947 | -122.422758971142 | (37.7507282726947, -122.422758971142) | 2 | 4 | 5 | 28859 | 19 | |||
181202 | 221498 | DPW Maintained 1 | Acacia stenophylla :: Shoestring Acacia 30 | 600x Guerrero St | 5 | Median : Cutout | Tree | DPW 1 | 3 | Width 3ft | 6005599.77613 | 2105242.7413 | 37.7609122108583 | -122.423734955914 | (37.7609122108583, -122.423734955914) | 2 | 4 | 5 | 28859 | 19 | |||
180105 | 221568 | DPW Maintained 1 | Acacia stenophylla :: Shoestring Acacia 30 | 359 Diamond St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 3ft | 6001813.22675 | 2103761.96483 | 37.7566318794794 | -122.436724942504 | (37.7566318794794, -122.436724942504) | 2 | 4 | 5 | 28862 | 3 | |||
179554 | 110784 | DPW Maintained 1 | Acacia stenophylla :: Shoestring Acacia 30 | 1000X GUERRERO ST | 13 | Median : Cutout | Tree | DPW 1 | 05/26/2015 02:11:00 PM | 3 | 3x3 | 6005663 | 2103080 | 37.7549773975701 | -122.423362541701 | (37.7549773975701, -122.423362541701) | 2 | 4 | 5 | 28859 | 19 | ||
178245 | 56594 | Permitted Site 7 | Acacia stenophylla :: Shoestring Acacia 30 | 533 Laidley St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/16/2012 12:00:00 AM | 3 | 3x3 | Permit Number 768959 | 6003224 | 2096098 | 37.7356684939052 | -122.431298930259 | (37.7356684939052, -122.431298930259) | 2 | 7 | 5 | 63 | 7 | |
177960 | 221491 | DPW Maintained 1 | Acacia stenophylla :: Shoestring Acacia 30 | 500x Guerrero St | 11 | Median : Cutout | Tree | DPW 1 | 1 | Width 3ft | 6005578.642 | 2105634.14294 | 37.7619857144891 | -122.423835881448 | (37.7619857144891, -122.423835881448) | 8 | 4 | 5 | 28859 | 19 | |||
177826 | 91237 | DPW Maintained 1 | Acacia stenophylla :: Shoestring Acacia 30 | 808 Guerrero St | 1 | Median : Cutout | Tree | DPW 1 | 11/20/2009 12:00:00 AM | 3 | 4x15 | 6005611 | 2104262 | 37.7582199589604 | -122.423626406477 | (37.7582199589604, -122.423626406477) | 2 | 4 | 5 | 28859 | 19 | ||
176610 | 43726 | Permitted Site 7 | Acacia stenophylla :: Shoestring Acacia 30 | 760 Lakeview Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/25/2000 12:00:00 AM | Permit Number 43365 | 5994428.64681371 | 2089956.34861374 | 37.7183026346731 | -122.461262575973 | (37.7183026346731, -122.461262575973) | 9 | 8 | 6 | 28861 | 24 | |||
176441 | 110759 | DPW Maintained 1 | Acacia stenophylla :: Shoestring Acacia 30 | 300X GUERRERO ST | 1 | Median : Cutout | Tree | DPW 1 | 06/19/2015 10:59:00 AM | 3 | 3x3 | 6005492 | 2106949 | 37.7655911088206 | -122.424229059984 | (37.7655911088206, -122.424229059984) | 8 | 4 | 5 | 28853 | 19 | ||
176363 | 221550 | DPW Maintained 1 | Acacia stenophylla :: Shoestring Acacia 30 | 1000x Guerrero St | 7 | Median : Cutout | Tree | DPW 1 | 1 | Width 3ft | 6005729.97057 | 2102894.68155 | 37.7544723356343 | -122.423117766494 | (37.7544723356343, -122.423117766494) | 2 | 4 | 5 | 28859 | 19 | |||
175781 | 221463 | DPW Maintained 1 | Acacia stenophylla :: Shoestring Acacia 30 | 300x Guerrero St | 8 | Median : Cutout | Tree | DPW 1 | 06/08/2017 12:00:00 AM | 3 | Width 3ft | 6005505.30672 | 2106900.54865 | 37.7654588242817 | -122.424179588833 | (37.7654588242817, -122.424179588833) | 8 | 4 | 5 | 28853 | 19 | ||
175672 | 221477 | DPW Maintained 1 | Acacia stenophylla :: Shoestring Acacia 30 | 400x Guerrero St | 10 | Median : Cutout | Tree | DPW 1 | 04/29/2015 05:29:00 AM | 1 | Width 3ft | 6005543.73868 | 2106251.90953 | 37.7636799850545 | -122.424000531101 | (37.7636799850545, -122.424000531101) | 8 | 4 | 5 | 28859 | 19 | ||
174659 | 221511 | DPW Maintained 1 | Acacia stenophylla :: Shoestring Acacia 30 | 1300x Guerrero St | 11 | Median : Cutout | Tree | DPW 1 | 6 | Width 3ft | 6005835.54562 | 2100976.57743 | 37.7492116209326 | -122.422616365666 | (37.7492116209326, -122.422616365666) | 2 | 4 | 5 | 28859 | 19 | |||
174532 | 91273 | DPW Maintained 1 | Acacia stenophylla :: Shoestring Acacia 30 | 1140x Guerrero St | 1 | Median : Cutout | Tree | DPW 1 | 11/20/2009 12:00:00 AM | 3 | 6005718 | 2102324 | 37.7529047007181 | -122.423118602517 | (37.7529047007181, -122.423118602517) | 2 | 4 | 5 | 28859 | 19 | |||
173380 | 91281 | DPW Maintained 1 | Acacia stenophylla :: Shoestring Acacia 30 | 1212x Guerrero St | 1 | Median : Cutout | Tree | DPW 1 | 11/20/2008 12:00:00 AM | 3 | 6005738 | 2101906 | 37.7517580978369 | -122.42301973134 | (37.7517580978369, -122.42301973134) | 2 | 4 | 5 | 28859 | 19 | |||
172006 | 110783 | DPW Maintained 1 | Acacia stenophylla :: Shoestring Acacia 30 | 1000X GUERRERO ST | 12 | Median : Cutout | Tree | DPW 1 | 05/26/2015 02:16:00 PM | 3 | 3x3 | 6005663 | 2103080 | 37.7549773975701 | -122.423362541701 | (37.7549773975701, -122.423362541701) | 2 | 4 | 5 | 28859 | 19 | ||
171592 | 221452 | DPW Maintained 1 | Acacia stenophylla :: Shoestring Acacia 30 | 200x Guerrero St | 4 | Median : Cutout | Tree | DPW 1 | 02/09/2016 11:41:00 AM | 1 | Width 3ft | 6005465.56003 | 2107641.57919 | 37.7674912732207 | -122.424369774755 | (37.7674912732207, -122.424369774755) | 8 | 4 | 5 | 28853 | 19 | ||
171275 | 109699 | DPW Maintained 1 | Acacia stenophylla :: Shoestring Acacia 30 | 600x GUERRERO ST | 7 | Median : Cutout | Tree | DPW 1 | 02/28/2015 11:10:00 PM | 3 | 3x3 | 6005435.8 | 2105392.6 | 37.7613144297161 | -122.424312736622 | (37.7613144297161, -122.424312736622) | 2 | 4 | 5 | 28859 | 19 | ||
170754 | 91277 | DPW Maintained 1 | Acacia stenophylla :: Shoestring Acacia 30 | 1170x Guerrero St | 1 | Median : Cutout | Tree | DPW 1 | 11/20/2008 12:00:00 AM | 3 | 6005728 | 2102148 | 37.752422009696 | -122.423071511908 | (37.752422009696, -122.423071511908) | 2 | 4 | 5 | 28859 | 19 | |||
170354 | 91272 | DPW Maintained 1 | Acacia stenophylla :: Shoestring Acacia 30 | 1136x Guerrero St | 1 | Median : Cutout | Tree | DPW 1 | 11/20/2009 12:00:00 AM | 3 | 6005717 | 2102348 | 37.7529705427373 | -122.423123766486 | (37.7529705427373, -122.423123766486) | 2 | 4 | 5 | 28859 | 19 | |||
170287 | 110760 | DPW Maintained 1 | Acacia stenophylla :: Shoestring Acacia 30 | 300X GUERRERO ST | 2 | Median : Cutout | Tree | DPW 1 | 06/19/2015 10:54:00 AM | 3 | 3x3 | 6005492 | 2106949 | 37.7655911088206 | -122.424229059984 | (37.7655911088206, -122.424229059984) | 8 | 4 | 5 | 28853 | 19 | ||
169286 | 221474 | DPW Maintained 1 | Acacia stenophylla :: Shoestring Acacia 30 | 400x Guerrero St | 7 | Median : Cutout | Tree | DPW 1 | 04/29/2015 10:16:00 AM | 1 | Width 3ft | 6005537.16302 | 2106367.52425 | 37.7639970644374 | -122.424031496564 | (37.7639970644374, -122.424031496564) | 8 | 4 | 5 | 28859 | 19 | ||
169041 | 115511 | DPW Maintained 1 | Acacia stenophylla :: Shoestring Acacia 30 | 200x Guerrero St | 2 | Median : Cutout | Tree | DPW 1 | 02/09/2016 12:48:00 PM | 3 | 6005415.2 | 2107753.5 | 37.7677957371292 | -122.424551925681 | (37.7677957371292, -122.424551925681) | 8 | 4 | 5 | 28853 | 19 | |||
168740 | 221570 | DPW Maintained 1 | Acacia stenophylla :: Shoestring Acacia 30 | 117 Alpine Ter | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 3ft | 6001705.56397 | 2108155.3423 | 37.7686889012963 | -122.437411868978 | (37.7686889012963, -122.437411868978) | 15 | 5 | 5 | 29492 | 3 | |||
167540 | 221475 | DPW Maintained 1 | Acacia stenophylla :: Shoestring Acacia 30 | 400x Guerrero St | 8 | Median : Cutout | Tree | DPW 1 | 04/29/2015 10:13:00 AM | 1 | Width 3ft | 6005538.26376 | 2106334.58706 | 37.7639066888645 | -122.424025347 | (37.7639066888645, -122.424025347) | 8 | 4 | 5 | 28859 | 19 | ||
166262 | 110762 | DPW Maintained 1 | Acacia stenophylla :: Shoestring Acacia 30 | 300X GUERRERO ST | 4 | Median : Cutout | Tree | DPW 1 | 06/19/2015 10:45:00 AM | 3 | 3x3 | 6005492 | 2106949 | 37.7655911088206 | -122.424229059984 | (37.7655911088206, -122.424229059984) | 8 | 4 | 5 | 28853 | 19 | ||
165700 | 221422 | DPW Maintained 1 | Acacia stenophylla :: Shoestring Acacia 30 | 800x Guerrero St | 10 | Median : Cutout | Tree | DPW 1 | 6 | Width 3ft | 6005661.88318 | 2104154.96713 | 37.7579289437835 | -122.42344282103 | (37.7579289437835, -122.42344282103) | 2 | 4 | 5 | 28859 | 19 | |||
163402 | 110782 | DPW Maintained 1 | Acacia stenophylla :: Shoestring Acacia 30 | 1000X GUERRERO ST | 11 | Median : Cutout | Tree | DPW 1 | 05/26/2015 02:21:00 PM | 3 | 3x3 | 6005663 | 2103080 | 37.7549773975701 | -122.423362541701 | (37.7549773975701, -122.423362541701) | 2 | 4 | 5 | 28859 | 19 | ||
162980 | 96193 | Undocumented 4 | Acacia stenophylla :: Shoestring Acacia 30 | 1640 Jerrold Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | 4x50 | 6015077.4 | 2097255.4 | 37.7395111076977 | -122.390397652393 | (37.7395111076977, -122.390397652393) | 10 | 3 | 8 | 58 | 1 | |||
162959 | 91286 | DPW Maintained 1 | Acacia stenophylla :: Shoestring Acacia 30 | 1212x Guerrero St | 6 | Median : Cutout | Tree | DPW 1 | 11/20/2008 12:00:00 AM | 3 | 6005738 | 2101906 | 37.7517580978369 | -122.42301973134 | (37.7517580978369, -122.42301973134) | 2 | 4 | 5 | 28859 | 19 | |||
162764 | 91266 | DPW Maintained 1 | Acacia stenophylla :: Shoestring Acacia 30 | 1100X Guerrero St | 2 | Median : Cutout | Tree | DPW 1 | 06/21/2016 01:48:00 PM | 3 | 3x500 | 6005744.445578 | 2102548.346221 | 37.7535221958931 | -122.423043093148 | (37.7535221958931, -122.423043093148) | 2 | 4 | 5 | 28859 | 19 | ||
162604 | 115521 | DPW Maintained 1 | Acacia stenophylla :: Shoestring Acacia 30 | 200x Guerrero St | 12 | Median : Cutout | Tree | DPW 1 | 6005415.2 | 2107753.5 | 37.7677957371292 | -122.424551925681 | (37.7677957371292, -122.424551925681) | 8 | 4 | 5 | 28853 | 19 | |||||
162498 | 221455 | DPW Maintained 1 | Acacia stenophylla :: Shoestring Acacia 30 | 200x Guerrero St | 1 | Median : Cutout | Tree | DPW 1 | 02/09/2016 12:55:00 PM | 1 | Width 3ft | 6005458.87953 | 2107745.71785 | 37.7677768358576 | -122.424400289657 | (37.7677768358576, -122.424400289657) | 8 | 4 | 5 | 28853 | 19 | ||
160656 | 221503 | DPW Maintained 1 | Acacia stenophylla :: Shoestring Acacia 30 | 600x Guerrero St | 10 | Median : Cutout | Tree | DPW 1 | 02/21/2015 11:06:00 PM | 2 | Width 3ft | 6005610.53101 | 2105047.42068 | 37.7603765134773 | -122.423683871708 | (37.7603765134773, -122.423683871708) | 2 | 4 | 5 | 28859 | 19 | ||
159812 | 91238 | DPW Maintained 1 | Acacia stenophylla :: Shoestring Acacia 30 | 812x Guerrero St | 1 | Median : Cutout | Tree | DPW 1 | 11/20/2008 12:00:00 AM | 3 | 6005612 | 2104238 | 37.7581541170225 | -122.423621241698 | (37.7581541170225, -122.423621241698) | 2 | 4 | 5 | 28859 | 19 | |||
159617 | 221472 | DPW Maintained 1 | Acacia stenophylla :: Shoestring Acacia 30 | 400x Guerrero St | 5 | Median : Cutout | Tree | DPW 1 | 04/29/2015 10:24:00 AM | 1 | Width 3ft | 6005534.31082 | 2106426.8401 | 37.7641597706703 | -122.424045579956 | (37.7641597706703, -122.424045579956) | 8 | 4 | 5 | 28859 | 19 | ||
159092 | 91256 | DPW Maintained 1 | Acacia stenophylla :: Shoestring Acacia 30 | 940X Guerrero St | 2 | Median : Cutout | Tree | DPW 1 | 11/20/2008 12:00:00 AM | 3 | 3x100 | 6005685.709261 | 2103490.611554 | 37.75610612308 | -122.423313194032 | (37.75610612308, -122.423313194032) | 2 | 4 | 5 | 28859 | 19 | ||
158366 | 110767 | DPW Maintained 1 | Acacia stenophylla :: Shoestring Acacia 30 | 300X GUERRERO ST | 9 | Median : Cutout | Tree | DPW 1 | 06/19/2015 10:25:00 AM | 3 | 3x3 | 6005492 | 2106949 | 37.7655911088206 | -122.424229059984 | (37.7655911088206, -122.424229059984) | 8 | 4 | 5 | 28853 | 19 | ||
157919 | 91293 | DPW Maintained 1 | Acacia stenophylla :: Shoestring Acacia 30 | 812x Guerrero St | 2 | Median : Cutout | Tree | DPW 1 | 11/20/2001 12:00:00 AM | 3 | 6005612 | 2104238 | 37.7581541170225 | -122.423621241698 | (37.7581541170225, -122.423621241698) | 2 | 4 | 5 | 28859 | 19 | |||
156993 | 110649 | DPW Maintained 1 | Acacia stenophylla :: Shoestring Acacia 30 | 400X GUERRERO ST | 12 | Median : Cutout | Tree | DPW 1 | 04/28/2015 07:46:00 PM | 3 | 3x3 | 6005439 | 2106552 | 37.7644980484366 | -122.424384135711 | (37.7644980484366, -122.424384135711) | 8 | 4 | 5 | 28859 | 19 | ||
156067 | 221563 | DPW Maintained 1 | Acacia stenophylla :: Shoestring Acacia 30 | 4286 23rd St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 3ft | 6001305.60339 | 2102341.6071 | 37.7527030580007 | -122.438378727412 | (37.7527030580007, -122.438378727412) | 2 | 4 | 5 | 28862 | 22 | |||
155313 | 221482 | DPW Maintained 1 | Acacia stenophylla :: Shoestring Acacia 30 | 500x Guerrero St | 2 | Median : Cutout | Tree | DPW 1 | 1 | Width 3ft | 6005559.28434 | 2105952.19302 | 37.7628579120838 | -122.423925449408 | (37.7628579120838, -122.423925449408) | 8 | 4 | 5 | 28859 | 19 | |||
154412 | 221458 | DPW Maintained 1 | Acacia stenophylla :: Shoestring Acacia 30 | 300x Guerrero St | 3 | Median : Cutout | Tree | DPW 1 | 06/19/2015 10:49:00 AM | 2 | Width 3ft | 6005493.2574 | 2107088.45627 | 37.7659740935515 | -122.424234630048 | (37.7659740935515, -122.424234630048) | 8 | 4 | 5 | 28853 | 19 | ||
154318 | 221443 | DPW Maintained 1 | Acacia stenophylla :: Shoestring Acacia 30 | 100x Guerrero St | 16 | Median : Cutout | Tree | DPW 1 | 1 | Width 3ft | 6005451.42839 | 2107920.02985 | 37.7682550341586 | -122.424438462286 | (37.7682550341586, -122.424438462286) | 8 | 4 | 5 | 28853 | 19 | |||
154018 | 221558 | DPW Maintained 1 | Acacia stenophylla :: Shoestring Acacia 30 | 1000x Guerrero St | 5 | Median : Cutout | Tree | DPW 1 | 3 | Width 3ft | 6005728.5881 | 2102926.21051 | 37.7545588288301 | -122.423124788381 | (37.7545588288301, -122.423124788381) | 2 | 4 | 5 | 28859 | 19 | |||
152774 | 221559 | DPW Maintained 1 | Acacia stenophylla :: Shoestring Acacia 30 | 1306 York St | 4 | : | Tree | Private 2 | 7 | Width 3ft | 6010039.89073 | 2101557.14399 | 37.7510420290671 | -122.408118546954 | (37.7510420290671, -122.408118546954) | 2 | 4 | 7 | 28859 | 19 | |||
152652 | 109694 | DPW Maintained 1 | Acacia stenophylla :: Shoestring Acacia 30 | 600x GUERRERO ST | 2 | Median : Cutout | Tree | DPW 1 | 02/21/2015 10:54:00 PM | 3 | 3x3 | 6005435.8 | 2105392.6 | 37.7613144297161 | -122.424312736622 | (37.7613144297161, -122.424312736622) | 2 | 4 | 5 | 28859 | 19 | ||
151302 | 91263 | DPW Maintained 1 | Acacia stenophylla :: Shoestring Acacia 30 | 970x Guerrero St | 1 | Median : Cutout | Tree | DPW 1 | 11/20/2008 12:00:00 AM | 3 | 3x100 | 6005695.03471 | 2103321.62929 | 37.7556426634019 | -122.423268931776 | (37.7556426634019, -122.423268931776) | 2 | 4 | 5 | 28859 | 19 | ||
150645 | 91274 | DPW Maintained 1 | Acacia stenophylla :: Shoestring Acacia 30 | 1144x Guerrero St | 1 | Median : Cutout | Tree | DPW 1 | 11/20/2009 12:00:00 AM | 3 | 6005719 | 2102300 | 37.7528388586979 | -122.423113438558 | (37.7528388586979, -122.423113438558) | 2 | 4 | 5 | 28859 | 19 | |||
150560 | 201715 | Undocumented 4 | Acacia stenophylla :: Shoestring Acacia 30 | 726 Jamestown Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 4ft | 6015296.60638 | 2088393.85947 | 37.715191240972 | -122.389021178889 | (37.715191240972, -122.389021178889) | 10 | 3 | 8 | 58 | 1 | |||
148907 | 91252 | DPW Maintained 1 | Acacia stenophylla :: Shoestring Acacia 30 | 908x Guerrero St | 1 | Median : Cutout | Tree | DPW 1 | 11/20/2008 12:00:00 AM | 3 | 3x100 | 6005675.762116 | 2103670.859284 | 37.7566004799608 | -122.423360407709 | (37.7566004799608, -122.423360407709) | 2 | 4 | 5 | 28859 | 19 | ||
147940 | 91288 | DPW Maintained 1 | Acacia stenophylla :: Shoestring Acacia 30 | 1250x Guerrero St | 1 | Median : Cutout | Tree | DPW 1 | 11/20/2008 12:00:00 AM | 3 | 6005751 | 2101683 | 37.7511465247873 | -122.422958927632 | (37.7511465247873, -122.422958927632) | 2 | 4 | 5 | 28859 | 19 | |||
145933 | 221566 | DPW Maintained 1 | Acacia stenophylla :: Shoestring Acacia 30 | 4286 23rd St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 3ft | 6001342.88204 | 2102344.46852 | 37.7527130350975 | -122.438250016433 | (37.7527130350975, -122.438250016433) | 2 | 4 | 5 | 28862 | 22 | |||
145226 | 91283 | DPW Maintained 1 | Acacia stenophylla :: Shoestring Acacia 30 | 1212x Guerrero St | 3 | Median : Cutout | Tree | DPW 1 | 11/20/2008 12:00:00 AM | 3 | 6005738 | 2101906 | 37.7517580978369 | -122.42301973134 | (37.7517580978369, -122.42301973134) | 2 | 4 | 5 | 28859 | 19 | |||
143846 | 221417 | DPW Maintained 1 | Acacia stenophylla :: Shoestring Acacia 30 | 800x Guerrero St | 3 | Median : Cutout | Tree | DPW 1 | 1 | Width 3ft | 6005673.16306 | 2103886.4908 | 37.7571924071266 | -122.423384724831 | (37.7571924071266, -122.423384724831) | 2 | 4 | 5 | 28859 | 19 | |||
143760 | 221493 | DPW Maintained 1 | Acacia stenophylla :: Shoestring Acacia 30 | 500x Guerrero St | 13 | Median : Cutout | Tree | DPW 1 | 2 | Width 3ft | 6005583.08285 | 2105563.4275 | 37.7617917972666 | -122.423815493808 | (37.7617917972666, -122.423815493808) | 8 | 4 | 5 | 28859 | 19 | |||
142764 | 221453 | DPW Maintained 1 | Acacia stenophylla :: Shoestring Acacia 30 | 200x Guerrero St | 3 | Median : Cutout | Tree | DPW 1 | 02/09/2016 12:40:00 PM | 1 | Width 3ft | 6005462.88888 | 2107675.99901 | 37.7675856309877 | -122.424381462352 | (37.7675856309877, -122.424381462352) | 8 | 4 | 5 | 28853 | 19 | ||
142437 | 221532 | DPW Maintained 1 | Acacia stenophylla :: Shoestring Acacia 30 | 1100x Guerrero St | 10 | Median : Cutout | Tree | DPW 1 | 8 | Width 3ft | 6005770.104 | 2102168.30473 | 37.7524801376575 | -122.422927352112 | (37.7524801376575, -122.422927352112) | 2 | 4 | 5 | 28859 | 19 | |||
142195 | 221437 | DPW Maintained 1 | Acacia stenophylla :: Shoestring Acacia 30 | 100x Guerrero St | 10 | Median : Cutout | Tree | DPW 1 | 07/15/2016 06:48:00 AM | 1 | Width 3ft | 6005441.98545 | 2108105.33614 | 37.7687633076137 | -122.424484307027 | (37.7687633076137, -122.424484307027) | 8 | 4 | 5 | 28853 | 19 | ||
141785 | 43728 | Permitted Site 7 | Acacia stenophylla :: Shoestring Acacia 30 | 760 Lakeview Ave | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/25/2000 12:00:00 AM | Permit Number 43365 | 5994428.64681371 | 2089956.34861374 | 37.7183026346731 | -122.461262575973 | (37.7183026346731, -122.461262575973) | 9 | 8 | 6 | 28861 | 24 | |||
141491 | 110772 | DPW Maintained 1 | Acacia stenophylla :: Shoestring Acacia 30 | 1000X GUERRERO ST | 1 | Median : Cutout | Tree | DPW 1 | 05/26/2015 03:10:00 PM | 3 | 3x3 | 6005663 | 2103080 | 37.7549773975701 | -122.423362541701 | (37.7549773975701, -122.423362541701) | 2 | 4 | 5 | 28859 | 19 | ||
140820 | 221534 | DPW Maintained 1 | Acacia stenophylla :: Shoestring Acacia 30 | 1100x Guerrero St | 8 | Median : Cutout | Tree | DPW 1 | 7 | Width 3ft | 6005765.63484 | 2102254.12398 | 37.7527155253202 | -122.422948906168 | (37.7527155253202, -122.422948906168) | 2 | 4 | 5 | 28859 | 19 | |||
140454 | 91265 | DPW Maintained 1 | Acacia stenophylla :: Shoestring Acacia 30 | 986x Guerrero St | 1 | Median : Cutout | Tree | DPW 1 | 11/20/2008 12:00:00 AM | 3 | 3x100 | 6005700.008282 | 2103231.505425 | 37.7553954849101 | -122.423245325469 | (37.7553954849101, -122.423245325469) | 2 | 4 | 5 | 28859 | 19 | ||
138398 | 43727 | Permitted Site 7 | Acacia stenophylla :: Shoestring Acacia 30 | 760 Lakeview Ave | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/25/2000 12:00:00 AM | Permit Number 43365 | 5994428.64681371 | 2089956.34861374 | 37.7183026346731 | -122.461262575973 | (37.7183026346731, -122.461262575973) | 9 | 8 | 6 | 28861 | 24 | |||
137951 | 221439 | DPW Maintained 1 | Acacia stenophylla :: Shoestring Acacia 30 | 100x Guerrero St | 12 | Median : Cutout | Tree | DPW 1 | 1 | Width 3ft | 6005446.76573 | 2108031.65533 | 37.7685612677047 | -122.424462530821 | (37.7685612677047, -122.424462530821) | 8 | 4 | 5 | 28853 | 19 | |||
136892 | 201711 | DPW Maintained 1 | Acacia stenophylla :: Shoestring Acacia 30 | 724 Jamestown Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 4ft | 6015357.64919 | 2088292.55339 | 37.7149164576082 | -122.388803118478 | (37.7149164576082, -122.388803118478) | 10 | 3 | 8 | 58 | 1 | |||
136051 | 221508 | DPW Maintained 1 | Acacia stenophylla :: Shoestring Acacia 30 | 1201 San Jose Ave | 15 | Front Yard : Yard | Tree | Private 2 | 1 | 6004291.81357 | 2095940.5809 | 37.7352967139782 | -122.427595874056 | (37.7352967139782, -122.427595874056) | 2 | 7 | 5 | 28861 | 2 | ||||
135542 | 187782 | DPW Maintained 1 | Acacia stenophylla :: Shoestring Acacia 30 | 101 Pennsylvania Ave | 14 | Front Yard : Yard | Tree | Private 2 | 1 | 6014325.58247 | 2106437.08289 | 37.764680319858 | -122.393639589702 | (37.764680319858, -122.393639589702) | 14 | 3 | 8 | 310 | 29 | ||||
135342 | 110761 | DPW Maintained 1 | Acacia stenophylla :: Shoestring Acacia 30 | 300X GUERRERO ST | 3 | Median : Cutout | Tree | DPW 1 | 06/19/2015 10:49:00 AM | 3 | 3x3 | 6005492 | 2106949 | 37.7655911088206 | -122.424229059984 | (37.7655911088206, -122.424229059984) | 8 | 4 | 5 | 28853 | 19 | ||
133232 | 109704 | DPW Maintained 1 | Acacia stenophylla :: Shoestring Acacia 30 | 600x GUERRERO ST | 12 | Median : Cutout | Tree | DPW 1 | 02/28/2015 10:40:00 PM | 3 | 3x3 | 6005435.8 | 2105392.6 | 37.7613144297161 | -122.424312736622 | (37.7613144297161, -122.424312736622) | 2 | 4 | 5 | 28859 | 19 | ||
132204 | 110622 | DPW Maintained 1 | Acacia stenophylla :: Shoestring Acacia 30 | 400X GUERRERO ST | 5 | Median : Cutout | Tree | DPW 1 | 04/29/2015 10:24:00 AM | 3 | 3x3 | 6005439 | 2106552 | 37.7644980484366 | -122.424384135711 | (37.7644980484366, -122.424384135711) | 8 | 4 | 5 | 28859 | 19 | ||
131495 | 56924 | DPW Maintained 1 | Acacia stenophylla :: Shoestring Acacia 30 | 140 Tingley St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 08/15/1974 12:00:00 AM | 3 | Permit Number 14167 | 6002240.5096 | 2093994.70553 | 37.7298375431559 | -122.434548888919 | (37.7298375431559, -122.434548888919) | 9 | 7 | 5 | 28861 | 25 | ||
131382 | 115515 | DPW Maintained 1 | Acacia stenophylla :: Shoestring Acacia 30 | 200x Guerrero St | 6 | Median : Cutout | Tree | DPW 1 | 02/09/2016 11:34:00 AM | 3 | 6005415.2 | 2107753.5 | 37.7677957371292 | -122.424551925681 | (37.7677957371292, -122.424551925681) | 8 | 4 | 5 | 28853 | 19 | |||
129565 | 109701 | DPW Maintained 1 | Acacia stenophylla :: Shoestring Acacia 30 | 600x GUERRERO ST | 9 | Median : Cutout | Tree | DPW 1 | 02/21/2015 11:07:00 PM | 3 | 3x3 | 6005435.8 | 2105392.6 | 37.7613144297161 | -122.424312736622 | (37.7613144297161, -122.424312736622) | 2 | 4 | 5 | 28859 | 19 | ||
129550 | 221465 | DPW Maintained 1 | Acacia stenophylla :: Shoestring Acacia 30 | 300x Guerrero St | 10 | Median : Cutout | Tree | DPW 1 | 06/19/2015 10:21:00 AM | 2 | Width 3ft | 6005511.34873 | 2106807.42823 | 37.7652034788903 | -122.424152067776 | (37.7652034788903, -122.424152067776) | 8 | 4 | 5 | 28853 | 19 | ||
129525 | 221459 | DPW Maintained 1 | Acacia stenophylla :: Shoestring Acacia 30 | 300x Guerrero St | 4 | Median : Cutout | Tree | DPW 1 | 06/19/2015 10:45:00 AM | 3 | Width 3ft | 6005495.53604 | 2107056.71588 | 37.7658870706576 | -122.424224491084 | (37.7658870706576, -122.424224491084) | 8 | 4 | 5 | 28853 | 19 | ||
128979 | 221516 | DPW Maintained 1 | Acacia stenophylla :: Shoestring Acacia 30 | 1300x Guerrero St | 6 | Median : Cutout | Tree | DPW 1 | 9 | Width 3ft | 6005827.473 | 2101138.31675 | 37.749655264584 | -122.422655773047 | (37.749655264584, -122.422655773047) | 2 | 4 | 5 | 28859 | 19 | |||
128664 | 115510 | DPW Maintained 1 | Acacia stenophylla :: Shoestring Acacia 30 | 200x Guerrero St | 1 | Median : Cutout | Tree | DPW 1 | 02/09/2016 12:55:00 PM | 3 | 6005415.2 | 2107753.5 | 37.7677957371292 | -122.424551925681 | (37.7677957371292, -122.424551925681) | 8 | 4 | 5 | 28853 | 19 | |||
127657 | 91271 | DPW Maintained 1 | Acacia stenophylla :: Shoestring Acacia 30 | 1130x Guerrero St | 1 | Median : Cutout | Tree | DPW 1 | 11/20/2009 12:00:00 AM | 3 | 6005715 | 2102383 | 37.7530665317795 | -122.423133170481 | (37.7530665317795, -122.423133170481) | 2 | 4 | 5 | 28859 | 19 | |||
126359 | 221444 | DPW Maintained 1 | Acacia stenophylla :: Shoestring Acacia 30 | 200x Guerrero St | 12 | Median : Cutout | Tree | DPW 1 | 1 | Width 3ft | 6005482.04836 | 2107327.01142 | 37.7666284762413 | -122.424290368213 | (37.7666284762413, -122.424290368213) | 8 | 4 | 5 | 28853 | 19 | |||
126324 | 221520 | DPW Maintained 1 | Acacia stenophylla :: Shoestring Acacia 30 | 1200x Guerrero St | 13 | Median : Cutout | Tree | DPW 1 | 6 | Width 3ft | 6005805.49109 | 2101500.8171 | 37.7506493670819 | -122.422757545722 | (37.7506493670819, -122.422757545722) | 2 | 4 | 5 | 28859 | 19 |
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) );