trees
68 rows where qCaretaker_id = 16 sorted by Location 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) |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
145251 | 108356 | Planning Code 138.1 required 2 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 250X Pixley St | 1 | Sidewalk: Curb side : Cutout | Tree | Fire Dept 16 | 11/02/2018 12:00:00 AM | 3 | 2x4 | Permit Number 773698 | 6002158.91155 | 2118972.60439 | 37.7984161192732 | -122.436618162405 | (37.7984161192732, -122.436618162405) | 13 | 9 | 1 | 57 | 17 | |
108505 | 108357 | DPW Maintained 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 250X Pixley St | 2 | Sidewalk: Curb side : Cutout | Tree | Fire Dept 16 | 11/02/2018 12:00:00 AM | 3 | 2x4 | Permit Number 773698 | 6002140.21513 | 2118970.44706 | 37.7984091333207 | -122.436682703142 | (37.7984091333207, -122.436682703142) | 13 | 9 | 1 | 57 | 17 | |
177003 | 108358 | DPW Maintained 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 250X Pixley St | 3 | Sidewalk: Curb side : Cutout | Tree | Fire Dept 16 | 11/02/2018 12:00:00 AM | 3 | 2x4 | Permit Number 773698 | 6002123.02459 | 2118966.98612 | 37.7983986535418 | -122.436741939704 | (37.7983986535418, -122.436741939704) | 13 | 9 | 1 | 57 | 17 | |
175352 | 27294 | DPW Maintained 1 | Pinus canariensis :: Canary Island Pine 35 | 7800X Geary Blvd | 1 | Median : Cutout | Tree | Fire Dept 16 | 02/12/2001 12:00:00 AM | 6 | 5X5 | 5982752.16339 | 2112399.44122 | 37.7792462157513 | -122.503283404585 | (37.7792462157513, -122.503283404585) | 11 | 6 | 2 | 55 | 26 | ||
82660 | 27295 | DPW Maintained 1 | Pinus canariensis :: Canary Island Pine 35 | 7800X Geary Blvd | 2 | Median : Cutout | Tree | Fire Dept 16 | 06/10/1999 12:00:00 AM | 6 | 5X5 | 5982729.47953 | 2112398.50568 | 37.7792423135673 | -122.503361806845 | (37.7792423135673, -122.503361806845) | 11 | 6 | 2 | 55 | 26 | ||
150758 | 27296 | DPW Maintained 1 | Pinus canariensis :: Canary Island Pine 35 | 7800X Geary Blvd | 3 | Median : Cutout | Tree | Fire Dept 16 | 06/10/1999 12:00:00 AM | 6 | 5X5 | 5982703.46074 | 2112397.79309 | 37.7792388274313 | -122.50345176232 | (37.7792388274313, -122.50345176232) | 11 | 6 | 2 | 55 | 26 | ||
136516 | 27297 | DPW Maintained 1 | Pinus canariensis :: Canary Island Pine 35 | 7800X Geary Blvd | 4 | Median : Cutout | Tree | Fire Dept 16 | 06/10/1999 12:00:00 AM | 6 | 5X5 | 5982680.86392 | 2112396.64212 | 37.7792343387449 | -122.503529847504 | (37.7792343387449, -122.503529847504) | 11 | 6 | 2 | 55 | 26 | ||
151464 | 27298 | DPW Maintained 1 | Pinus canariensis :: Canary Island Pine 35 | 7800X Geary Blvd | 5 | Median : Cutout | Tree | Fire Dept 16 | 06/10/1999 12:00:00 AM | 6 | 5X5 | 5982658.07107 | 2112395.9042 | 37.7792309725957 | -122.503608641413 | (37.7792309725957, -122.503608641413) | 11 | 6 | 2 | 55 | 26 | ||
161640 | 27299 | DPW Maintained 1 | Pinus canariensis :: Canary Island Pine 35 | 7800X Geary Blvd | 6 | Median : Cutout | Tree | Fire Dept 16 | 06/10/1999 12:00:00 AM | 6 | 5X5 | 5982630.17797 | 2112395.09735 | 37.7792271172593 | -122.503705073784 | (37.7792271172593, -122.503705073784) | 11 | 6 | 2 | 55 | 26 | ||
42129 | 111073 | Undocumented 4 | Juniperus chinensis :: Juniper 113 | 1450 IRVING ST | 2 | Sidewalk: Property side : Cutout | Tree | Fire Dept 16 | 3x3 | 5991201 | 2106639 | 37.7639226370674 | -122.473635352969 | (37.7639226370674, -122.473635352969) | 11 | 8 | 11 | 56 | 12 | ||||
193863 | 111072 | Undocumented 4 | Juniperus chinensis :: Juniper 113 | 1450 IRVING ST | 1 | Sidewalk: Property side : Cutout | Tree | Fire Dept 16 | 3x3 | 5991277 | 2106586 | 37.7637815143869 | -122.473368628437 | (37.7637815143869, -122.473368628437) | 11 | 8 | 11 | 56 | 12 | ||||
35237 | 116382 | Permitted Site 7 | Magnolia grandiflora :: Southern Magnolia 19 | 2501 25th St | 3 | Sidewalk: Curb side : Cutout | Tree | Fire Dept 16 | DPW for City Agency | 3x3 | 6011435.88896489 | 2101815.42613948 | 37.7518292809831 | -122.403309184671 | (37.7518292809831, -122.403309184671) | 10 | 4 | 8 | 28859 | 19 | |||
63178 | 67338 | Permitted Site 7 | Magnolia grandiflora :: Southern Magnolia 19 | 2501 25th St | 1 | Sidewalk: Curb side : Cutout | Tree | Fire Dept 16 | DPW for City Agency | 07/22/1992 12:00:00 AM | 3x3 | Permit Number 30822 | 6011435.88896489 | 2101815.42613948 | 37.7518292809831 | -122.403309184671 | (37.7518292809831, -122.403309184671) | 10 | 4 | 8 | 28859 | 19 | |
168314 | 6623 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 1415 Evans Ave | 6 | Sidewalk: Curb side : Cutout | Tree | Fire Dept 16 | 18 | 3x3 | 6016531.01979 | 2097819.10411 | 37.7411394528345 | -122.385410892796 | (37.7411394528345, -122.385410892796) | 10 | 3 | 8 | 58 | 1 | |||
48351 | 6624 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 1415 Evans Ave | 7 | Sidewalk: Curb side : Cutout | Tree | Fire Dept 16 | 02/04/2004 12:00:00 AM | 3 | 3x3 | 6016547.14534 | 2097807.00624 | 37.7411071266849 | -122.385354293091 | (37.7411071266849, -122.385354293091) | 10 | 3 | 8 | 58 | 1 | ||
146898 | 6625 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 1415 Evans Ave | 8 | Sidewalk: Curb side : Cutout | Tree | Fire Dept 16 | 11/24/1998 12:00:00 AM | 6 | 3x3 | 6016564.1874 | 2097795.2525 | 37.7410757961225 | -122.385294548421 | (37.7410757961225, -122.385294548421) | 10 | 3 | 8 | 58 | 1 | ||
176485 | 6626 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 1415 Evans Ave | 9 | Sidewalk: Curb side : Cutout | Tree | Fire Dept 16 | 11/24/1998 12:00:00 AM | 6 | 3x3 | 6016580.82562 | 2097781.51455 | 37.7410389949512 | -122.38523606192 | (37.7410389949512, -122.38523606192) | 10 | 3 | 8 | 58 | 1 | ||
3819 | 6627 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 1415 Evans Ave | 10 | Sidewalk: Curb side : Cutout | Tree | Fire Dept 16 | 11/24/1998 12:00:00 AM | 6 | 3x3 | 6016607.54293 | 2097762.50213 | 37.7409882686849 | -122.385142357926 | (37.7409882686849, -122.385142357926) | 10 | 3 | 8 | 58 | 1 | ||
31471 | 6631 | Permitted Site 7 | Acacia melanoxylon :: Blackwood Acacia 70 | 1415 Evans Ave | 14 | Sidewalk: Curb side : Cutout | Tree | Fire Dept 16 | 02/15/2001 12:00:00 AM | 18 | 3x3 | 6016617.7688071 | 2097746.8662364 | 37.740945901362 | -122.385105911093 | (37.740945901362, -122.385105911093) | 10 | 3 | 8 | 58 | 1 | ||
41490 | 6632 | Permitted Site 7 | Acacia melanoxylon :: Blackwood Acacia 70 | 1415 Evans Ave | 15 | Sidewalk: Curb side : Cutout | Tree | Fire Dept 16 | 18 | 3x3 | 6016617.7688071 | 2097746.8662364 | 37.740945901362 | -122.385105911093 | (37.740945901362, -122.385105911093) | 10 | 3 | 8 | 58 | 1 | |||
56232 | 6621 | Permitted Site 7 | Acacia melanoxylon :: Blackwood Acacia 70 | 1415 Evans Ave | 4 | Sidewalk: Curb side : Cutout | Tree | Fire Dept 16 | 18 | 3x3 | 6016617.7688071 | 2097746.8662364 | 37.740945901362 | -122.385105911093 | (37.740945901362, -122.385105911093) | 10 | 3 | 8 | 58 | 1 | |||
19639 | 6826 | Permitted Site 7 | Hymenosporum flavum :: Sweet Shade 125 | 1450X Fairfax Ave | 8 | Sidewalk: Curb side : Cutout | Tree | Fire Dept 16 | 12/19/2000 12:00:00 AM | 6 | 3X3 | 6016306.5293484 | 2097712.5542014 | 37.740834465841 | -122.386179680893 | (37.740834465841, -122.386179680893) | 10 | 3 | 8 | 58 | 1 | ||
20856 | 6820 | Permitted Site 7 | Hymenosporum flavum :: Sweet Shade 125 | 1450X Fairfax Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Fire Dept 16 | 12/19/2000 12:00:00 AM | 3 | 3X3 | 6016306.5293484 | 2097712.5542014 | 37.740834465841 | -122.386179680893 | (37.740834465841, -122.386179680893) | 10 | 3 | 8 | 58 | 1 | ||
21328 | 6821 | Permitted Site 7 | Hymenosporum flavum :: Sweet Shade 125 | 1450X Fairfax Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Fire Dept 16 | 12/19/2000 12:00:00 AM | 3 | 3X3 | 6016306.5293484 | 2097712.5542014 | 37.740834465841 | -122.386179680893 | (37.740834465841, -122.386179680893) | 10 | 3 | 8 | 58 | 1 | ||
23319 | 6827 | Permitted Site 7 | Hymenosporum flavum :: Sweet Shade 125 | 1450X Fairfax Ave | 9 | Sidewalk: Curb side : Cutout | Tree | Fire Dept 16 | 12/19/2000 12:00:00 AM | 6 | 3X3 | 6016306.5293484 | 2097712.5542014 | 37.740834465841 | -122.386179680893 | (37.740834465841, -122.386179680893) | 10 | 3 | 8 | 58 | 1 | ||
27391 | 6825 | Permitted Site 7 | Ficus nitida :: Laurel Fig 53 | 1450X Fairfax Ave | 6 | Sidewalk: Curb side : Cutout | Tree | Fire Dept 16 | 12 | 3X3 | 6016306.5293484 | 2097712.5542014 | 37.740834465841 | -122.386179680893 | (37.740834465841, -122.386179680893) | 10 | 3 | 8 | 58 | 1 | |||
37080 | 6828 | Permitted Site 7 | Ficus nitida :: Laurel Fig 53 | 1450X Fairfax Ave | 10 | Sidewalk: Curb side : Cutout | Tree | Fire Dept 16 | 12 | 3X3 | 6016306.5293484 | 2097712.5542014 | 37.740834465841 | -122.386179680893 | (37.740834465841, -122.386179680893) | 10 | 3 | 8 | 58 | 1 | |||
42767 | 6830 | Permitted Site 7 | Hymenosporum flavum :: Sweet Shade 125 | 1450X Fairfax Ave | 12 | Sidewalk: Curb side : Cutout | Tree | Fire Dept 16 | 12/19/2000 12:00:00 AM | 6 | 3X3 | 6016306.5293484 | 2097712.5542014 | 37.740834465841 | -122.386179680893 | (37.740834465841, -122.386179680893) | 10 | 3 | 8 | 58 | 1 | ||
115039 | 6823 | Permitted Site 7 | Magnolia grandiflora :: Southern Magnolia 19 | 1450X Fairfax Ave | 5 | Sidewalk: Curb side : Cutout | Tree | Fire Dept 16 | 03/30/2006 12:00:00 AM | 3 | 3X3 | 6016306.5293484 | 2097712.5542014 | 37.740834465841 | -122.386179680893 | (37.740834465841, -122.386179680893) | 10 | 3 | 8 | 58 | 1 | ||
129171 | 27857 | Permitted Site 7 | Ficus nitida :: Laurel Fig 53 | 1450X Fairfax Ave | 7 | Sidewalk: Curb side : Cutout | Tree | Fire Dept 16 | 12 | 3X3 | 6016306.5293484 | 2097712.5542014 | 37.740834465841 | -122.386179680893 | (37.740834465841, -122.386179680893) | 10 | 3 | 8 | 58 | 1 | |||
131896 | 6822 | Permitted Site 7 | Hymenosporum flavum :: Sweet Shade 125 | 1450X Fairfax Ave | 3 | Sidewalk: Curb side : Cutout | Tree | Fire Dept 16 | 03/30/2006 12:00:00 AM | 3 | 3X3 | 6016306.5293484 | 2097712.5542014 | 37.740834465841 | -122.386179680893 | (37.740834465841, -122.386179680893) | 10 | 3 | 8 | 58 | 1 | ||
155772 | 6824 | Permitted Site 7 | Acacia melanoxylon :: Blackwood Acacia 70 | 1450X Fairfax Ave | 4 | Sidewalk: Curb side : Cutout | Tree | Fire Dept 16 | 18 | 3X3 | 6016306.5293484 | 2097712.5542014 | 37.740834465841 | -122.386179680893 | (37.740834465841, -122.386179680893) | 10 | 3 | 8 | 58 | 1 | |||
158152 | 6829 | Permitted Site 7 | Ficus nitida :: Laurel Fig 53 | 1450X Fairfax Ave | 11 | Sidewalk: Curb side : Cutout | Tree | Fire Dept 16 | 12 | 3X3 | 6016306.5293484 | 2097712.5542014 | 37.740834465841 | -122.386179680893 | (37.740834465841, -122.386179680893) | 10 | 3 | 8 | 58 | 1 | |||
165985 | 6831 | Permitted Site 7 | Magnolia grandiflora :: Southern Magnolia 19 | 1450X Fairfax Ave | 14 | Sidewalk: Curb side : Cutout | Tree | Fire Dept 16 | 03/30/2006 12:00:00 AM | 3 | 3X3 | 6016306.5293484 | 2097712.5542014 | 37.740834465841 | -122.386179680893 | (37.740834465841, -122.386179680893) | 10 | 3 | 8 | 58 | 1 | ||
72256 | 14968 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 400X Mendell St | 1 | Sidewalk: Curb side : Cutout | Tree | Fire Dept 16 | 12 | 3X3 | 6016667.04052 | 2097697.80462 | 37.7408139135396 | -122.384932128834 | (37.7408139135396, -122.384932128834) | 10 | 3 | 8 | 58 | 1 | |||
61635 | 6819 | DPW Maintained 1 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 | 1400X Fairfax Ave | 11 | Sidewalk: Curb side : Cutout | Tree | Fire Dept 16 | 12 | 3X3 | 6016343.96785 | 2097693.33127 | 37.7407837556653 | -122.386048891651 | (37.7407837556653, -122.386048891651) | 10 | 3 | 8 | 58 | 1 | |||
119100 | 14969 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 400X Mendell St | 2 | Sidewalk: Curb side : Cutout | Tree | Fire Dept 16 | 12 | 3x3 | 6016654.44168 | 2097681.89431 | 37.7407695301847 | -122.384974583115 | (37.7407695301847, -122.384974583115) | 10 | 3 | 8 | 58 | 1 | |||
103939 | 14970 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 400X Mendell St | 3 | Sidewalk: Curb side : Cutout | Tree | Fire Dept 16 | 18 | 3x3 | 6016646.28629 | 2097669.62437 | 37.7407353883164 | -122.385001926999 | (37.7407353883164, -122.385001926999) | 10 | 3 | 8 | 58 | 1 | |||
161719 | 14971 | DPW Maintained 1 | Quercus suber :: Cork Oak 78 | 400X Mendell St | 4 | Sidewalk: Curb side : Cutout | Tree | Fire Dept 16 | 02/25/2008 12:00:00 AM | 3 | 3X3 | 6016631.74011 | 2097650.02311 | 37.7406807626184 | -122.385050857322 | (37.7406807626184, -122.385050857322) | 10 | 3 | 8 | 58 | 1 | ||
160744 | 14972 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 400X Mendell St | 5 | Sidewalk: Curb side : Cutout | Tree | Fire Dept 16 | 12 | 3X3 | 6016621.68773 | 2097636.5481 | 37.7406432069202 | -122.385084676324 | (37.7406432069202, -122.385084676324) | 10 | 3 | 8 | 58 | 1 | |||
164473 | 14973 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 400X Mendell St | 6 | Sidewalk: Curb side : Cutout | Tree | Fire Dept 16 | 12 | 3X3 | 6016605.91834 | 2097618.21478 | 37.740591995028 | -122.385137924278 | (37.740591995028, -122.385137924278) | 10 | 3 | 8 | 58 | 1 | |||
117768 | 6814 | DPW Maintained 1 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 | 1400X Fairfax Ave | 6 | Sidewalk: Curb side : Cutout | Tree | Fire Dept 16 | 12 | 3X3 | 6016451.12132 | 2097615.70854 | 37.7405765491786 | -122.385672983138 | (37.7405765491786, -122.385672983138) | 10 | 3 | 8 | 58 | 1 | |||
56556 | 6813 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 1400X Fairfax Ave | 5 | Sidewalk: Curb side : Cutout | Tree | Fire Dept 16 | 12/15/1998 12:00:00 AM | 6 | 3X3 | 6016463.58165 | 2097607.01609 | 37.7405533709401 | -122.385629294058 | (37.7405533709401, -122.385629294058) | 10 | 3 | 8 | 58 | 1 | ||
139349 | 14974 | DPW Maintained 1 | Ceratonia siliqua :: Carob 5 | 400X Mendell St | 7 | Sidewalk: Curb side : Cutout | Tree | Fire Dept 16 | 12 | 3X3 | 6016589.22096 | 2097595.13367 | 37.7405276953073 | -122.385194050084 | (37.7405276953073, -122.385194050084) | 10 | 3 | 8 | 58 | 1 | |||
10875 | 6812 | DPW Maintained 1 | Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 2 | 1400X Fairfax Ave | 4 | Sidewalk: Curb side : Cutout | Tree | Fire Dept 16 | 08/13/2020 01:09:00 PM | 3 | 3X3 | 6016477.27072 | 2097595.73141 | 37.7405231429351 | -122.385581175844 | (37.7405231429351, -122.385581175844) | 10 | 3 | 8 | 58 | 1 | ||
84909 | 14975 | DPW Maintained 1 | Ceratonia siliqua :: Carob 5 | 400X Mendell St | 8 | Sidewalk: Curb side : Cutout | Tree | Fire Dept 16 | 12 | 3x3 | 6016578.93942 | 2097580.627 | 37.7404872941606 | -122.38522858943 | (37.7404872941606, -122.38522858943) | 10 | 3 | 8 | 58 | 1 | |||
171047 | 6811 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 1400X Fairfax Ave | 3 | Sidewalk: Curb side : Cutout | Tree | Fire Dept 16 | 03/30/2006 12:00:00 AM | 3 | 3X3 | 6016498.59648 | 2097579.96622 | 37.7404810348687 | -122.385506340556 | (37.7404810348687, -122.385506340556) | 10 | 3 | 8 | 58 | 1 | ||
25967 | 6810 | DPW Maintained 1 | :: 45 | 1400X Fairfax Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Fire Dept 16 | 03/30/2006 12:00:00 AM | 3 | 3X3 | 6016518.03729 | 2097563.61739 | 37.74043721991 | -122.38543798217 | (37.74043721991, -122.38543798217) | 10 | 3 | 8 | 58 | 1 | ||
110361 | 6809 | DPW Maintained 1 | :: 45 | 1400X Fairfax Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Fire Dept 16 | 12/19/2000 12:00:00 AM | 6 | 3X3 | 6016539.97847 | 2097547.42551 | 37.7403939741954 | -122.385360989424 | (37.7403939741954, -122.385360989424) | 10 | 3 | 8 | 58 | 1 | ||
46216 | 6816 | Permitted Site 7 | Ficus nitida :: Laurel Fig 53 | 1400X Fairfax Ave | 8 | Sidewalk: Curb side : Cutout | Tree | Fire Dept 16 | 12 | 3X3 | 6016560.8212721 | 2097522.8211505 | 37.7403275687029 | -122.385287208511 | (37.7403275687029, -122.385287208511) | 10 | 3 | 8 | 58 | 1 | |||
115268 | 6817 | Permitted Site 7 | Ficus nitida :: Laurel Fig 53 | 1400X Fairfax Ave | 9 | Sidewalk: Curb side : Cutout | Tree | Fire Dept 16 | 12 | 3X3 | 6016560.8212721 | 2097522.8211505 | 37.7403275687029 | -122.385287208511 | (37.7403275687029, -122.385287208511) | 10 | 3 | 8 | 58 | 1 | |||
188909 | 6818 | Permitted Site 7 | Ficus nitida :: Laurel Fig 53 | 1400X Fairfax Ave | 10 | Sidewalk: Curb side : Cutout | Tree | Fire Dept 16 | 12 | 3X3 | 6016560.8212721 | 2097522.8211505 | 37.7403275687029 | -122.385287208511 | (37.7403275687029, -122.385287208511) | 10 | 3 | 8 | 58 | 1 | |||
190734 | 6815 | Permitted Site 7 | Ficus nitida :: Laurel Fig 53 | 1400X Fairfax Ave | 7 | Sidewalk: Curb side : Cutout | Tree | Fire Dept 16 | 12 | 3X3 | 6016560.8212721 | 2097522.8211505 | 37.7403275687029 | -122.385287208511 | (37.7403275687029, -122.385287208511) | 10 | 3 | 8 | 58 | 1 | |||
28370 | 29458 | Permitted Site 7 | Lophostemon confertus :: Brisbane Box 11 | 1809X Ingalls St | 4 | Sidewalk: Curb side : Cutout | Tree | Fire Dept 16 | 02/28/2006 12:00:00 AM | 12 | 3X3 | 6016520.1701445 | 2092944.0657869 | 37.7277529727716 | -122.385108820711 | (37.7277529727716, -122.385108820711) | 10 | 3 | 8 | 58 | 1 | ||
42315 | 29508 | Permitted Site 7 | Lophostemon confertus :: Brisbane Box 11 | 1850X Ingalls St | 2 | Sidewalk: Curb side : Cutout | Tree | Fire Dept 16 | 02/28/2006 12:00:00 AM | 3 | 3x3 | 6016520.1701445 | 2092944.0657869 | 37.7277529727716 | -122.385108820711 | (37.7277529727716, -122.385108820711) | 10 | 3 | 8 | 58 | 1 | ||
67214 | 29455 | Permitted Site 7 | Lophostemon confertus :: Brisbane Box 11 | 1809X Ingalls St | 1 | Sidewalk: Curb side : Cutout | Tree | Fire Dept 16 | 02/28/2006 12:00:00 AM | 12 | 3X3 | 6016520.1701445 | 2092944.0657869 | 37.7277529727716 | -122.385108820711 | (37.7277529727716, -122.385108820711) | 10 | 3 | 8 | 58 | 1 | ||
86267 | 29509 | Permitted Site 7 | Lophostemon confertus :: Brisbane Box 11 | 1850X Ingalls St | 3 | Sidewalk: Curb side : Cutout | Tree | Fire Dept 16 | 02/28/2006 12:00:00 AM | 12 | 3x3 | 6016520.1701445 | 2092944.0657869 | 37.7277529727716 | -122.385108820711 | (37.7277529727716, -122.385108820711) | 10 | 3 | 8 | 58 | 1 | ||
120363 | 29456 | Permitted Site 7 | Lophostemon confertus :: Brisbane Box 11 | 1809X Ingalls St | 2 | Sidewalk: Curb side : Cutout | Tree | Fire Dept 16 | 02/27/2008 12:00:00 AM | 3 | 3X3 | 6016520.1701445 | 2092944.0657869 | 37.7277529727716 | -122.385108820711 | (37.7277529727716, -122.385108820711) | 10 | 3 | 8 | 58 | 1 | ||
150090 | 29507 | Permitted Site 7 | Lophostemon confertus :: Brisbane Box 11 | 1850X Ingalls St | 1 | Sidewalk: Curb side : Cutout | Tree | Fire Dept 16 | 02/28/2006 12:00:00 AM | 16 | 3x3 | 6016520.1701445 | 2092944.0657869 | 37.7277529727716 | -122.385108820711 | (37.7277529727716, -122.385108820711) | 10 | 3 | 8 | 58 | 1 | ||
154274 | 199930 | DPW Maintained 1 | Tristania conferta :: 61 | 1801 Ingalls St | 4 | Sidewalk: Curb side : Cutout | Tree | Fire Dept 16 | 02/28/2006 12:00:00 AM | 6 | Width 0ft | 6016497.9258 | 2092921.8231 | 37.7276906682215 | -122.385184171361 | (37.7276906682215, -122.385184171361) | 10 | 3 | 8 | 58 | 1 | ||
64162 | 29457 | Permitted Site 7 | Lophostemon confertus :: Brisbane Box 11 | 1809X Ingalls St | 3 | Sidewalk: Curb side : Cutout | Tree | Fire Dept 16 | 02/28/2006 12:00:00 AM | 12 | 3x3 | 6016492.91829 | 2092912.51025 | 37.7276648199576 | -122.38520083393 | (37.7276648199576, -122.38520083393) | 10 | 3 | 8 | 58 | 1 | ||
191358 | 199929 | DPW Maintained 1 | Tristania conferta :: 61 | 1801 Ingalls St | 3 | Sidewalk: Curb side : Cutout | Tree | Fire Dept 16 | 02/28/2006 12:00:00 AM | 6 | Width 0ft | 6016487.4596 | 2092903.0942 | 37.727638663365 | -122.385219049049 | (37.727638663365, -122.385219049049) | 10 | 3 | 8 | 58 | 1 | ||
64865 | 29451 | Permitted Site 7 | Lophostemon confertus :: Brisbane Box 11 | 1829X Ingalls St | 1 | Sidewalk: Curb side : Cutout | Tree | Fire Dept 16 | 02/28/2006 12:00:00 AM | 12 | 3X3 | 6016488.0524002 | 2092900.9411781 | 37.7276327843847 | -122.385216849755 | (37.7276327843847, -122.385216849755) | 10 | 3 | 8 | 58 | 1 | ||
94432 | 29453 | Permitted Site 7 | Lophostemon confertus :: Brisbane Box 11 | 1829X Ingalls St | 3 | Sidewalk: Curb side : Cutout | Tree | Fire Dept 16 | 02/28/2006 12:00:00 AM | 12 | 3X3 | 6016488.0524002 | 2092900.9411781 | 37.7276327843847 | -122.385216849755 | (37.7276327843847, -122.385216849755) | 10 | 3 | 8 | 58 | 1 | ||
124059 | 29454 | Permitted Site 7 | Lophostemon confertus :: Brisbane Box 11 | 1829X Ingalls St | 4 | Sidewalk: Curb side : Cutout | Tree | Fire Dept 16 | 02/28/2006 12:00:00 AM | 8 | 3X3 | 6016488.0524002 | 2092900.9411781 | 37.7276327843847 | -122.385216849755 | (37.7276327843847, -122.385216849755) | 10 | 3 | 8 | 58 | 1 | ||
170395 | 29452 | Permitted Site 7 | Lophostemon confertus :: Brisbane Box 11 | 1829X Ingalls St | 2 | Sidewalk: Curb side : Cutout | Tree | Fire Dept 16 | 02/28/2006 12:00:00 AM | 12 | 3X3 | 6016488.0524002 | 2092900.9411781 | 37.7276327843847 | -122.385216849755 | (37.7276327843847, -122.385216849755) | 10 | 3 | 8 | 58 | 1 | ||
45411 | 199928 | DPW Maintained 1 | Tristania conferta :: 61 | 1801 Ingalls St | 2 | Sidewalk: Curb side : Cutout | Tree | Fire Dept 16 | 02/27/2008 12:00:00 AM | 4 | Width 0ft | 6016476.4427 | 2092884.9162 | 37.7275881406952 | -122.385255868852 | (37.7275881406952, -122.385255868852) | 10 | 3 | 8 | 58 | 1 | ||
92591 | 199927 | DPW Maintained 1 | Tristania conferta :: 61 | 1801 Ingalls St | 1 | Sidewalk: Curb side : Cutout | Tree | Fire Dept 16 | 02/28/2006 12:00:00 AM | 5 | Width 0ft | 6016464.324 | 2092869.4925 | 37.7275451198245 | -122.385296689415 | (37.7275451198245, -122.385296689415) | 10 | 3 | 8 | 58 | 1 |
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) );