trees
8,298 rows where qLegalStatus_id = 4 sorted by Longitude
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) |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
138225 | 101082 | Undocumented 4 | Lophostemon confertus :: Brisbane Box 11 | 1699X Tennessee St | 8 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | 3x3 | 6015823 | 2101385 | 37.7508914678049 | -122.388107781388 | (37.7508914678049, -122.388107781388) | 10 | 3 | 8 | 28856 | 1 | |||
172696 | 101083 | Undocumented 4 | Lophostemon confertus :: Brisbane Box 11 | 1699X Tennessee St | 9 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | 3x3 | 6015823 | 2101385 | 37.7508914678049 | -122.388107781388 | (37.7508914678049, -122.388107781388) | 10 | 3 | 8 | 28856 | 1 | |||
653 | 262559 | Undocumented 4 | Washingtonia robusta :: Mexican Fan Palm 72 | 1801 03rd St | 9 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6015928 | 2106803 | 37.7657739601897 | -122.388122739596 | (37.7657739601897, -122.388122739596) | 14 | 3 | 9 | 310 | 29 | ||||
1778 | 262558 | Undocumented 4 | Washingtonia robusta :: Mexican Fan Palm 72 | 1801 03rd St | 8 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6015928 | 2106803 | 37.7657739601897 | -122.388122739596 | (37.7657739601897, -122.388122739596) | 14 | 3 | 9 | 310 | 29 | ||||
1943 | 262553 | Undocumented 4 | Washingtonia robusta :: Mexican Fan Palm 72 | 1801 03rd St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6015928 | 2106803 | 37.7657739601897 | -122.388122739596 | (37.7657739601897, -122.388122739596) | 14 | 3 | 9 | 310 | 29 | ||||
2094 | 262557 | Undocumented 4 | Washingtonia robusta :: Mexican Fan Palm 72 | 1801 03rd St | 7 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6015928 | 2106803 | 37.7657739601897 | -122.388122739596 | (37.7657739601897, -122.388122739596) | 14 | 3 | 9 | 310 | 29 | ||||
2398 | 262570 | Undocumented 4 | Washingtonia robusta :: Mexican Fan Palm 72 | 1801 03rd St | 20 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6015928 | 2106803 | 37.7657739601897 | -122.388122739596 | (37.7657739601897, -122.388122739596) | 14 | 3 | 9 | 310 | 29 | ||||
2589 | 262566 | Undocumented 4 | Washingtonia robusta :: Mexican Fan Palm 72 | 1801 03rd St | 16 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6015928 | 2106803 | 37.7657739601897 | -122.388122739596 | (37.7657739601897, -122.388122739596) | 14 | 3 | 9 | 310 | 29 | ||||
3606 | 262564 | Undocumented 4 | Washingtonia robusta :: Mexican Fan Palm 72 | 1801 03rd St | 14 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6015928 | 2106803 | 37.7657739601897 | -122.388122739596 | (37.7657739601897, -122.388122739596) | 14 | 3 | 9 | 310 | 29 | ||||
4185 | 262568 | Undocumented 4 | Washingtonia robusta :: Mexican Fan Palm 72 | 1801 03rd St | 18 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6015928 | 2106803 | 37.7657739601897 | -122.388122739596 | (37.7657739601897, -122.388122739596) | 14 | 3 | 9 | 310 | 29 | ||||
4200 | 262567 | Undocumented 4 | Washingtonia robusta :: Mexican Fan Palm 72 | 1801 03rd St | 17 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6015928 | 2106803 | 37.7657739601897 | -122.388122739596 | (37.7657739601897, -122.388122739596) | 14 | 3 | 9 | 310 | 29 | ||||
5772 | 262554 | Undocumented 4 | Washingtonia robusta :: Mexican Fan Palm 72 | 1801 03rd St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6015928 | 2106803 | 37.7657739601897 | -122.388122739596 | (37.7657739601897, -122.388122739596) | 14 | 3 | 9 | 310 | 29 | ||||
7613 | 262571 | Undocumented 4 | Washingtonia robusta :: Mexican Fan Palm 72 | 1801 03rd St | 21 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6015928 | 2106803 | 37.7657739601897 | -122.388122739596 | (37.7657739601897, -122.388122739596) | 14 | 3 | 9 | 310 | 29 | ||||
8223 | 262569 | Undocumented 4 | Washingtonia robusta :: Mexican Fan Palm 72 | 1801 03rd St | 19 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6015928 | 2106803 | 37.7657739601897 | -122.388122739596 | (37.7657739601897, -122.388122739596) | 14 | 3 | 9 | 310 | 29 | ||||
9120 | 262556 | Undocumented 4 | Washingtonia robusta :: Mexican Fan Palm 72 | 1801 03rd St | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6015928 | 2106803 | 37.7657739601897 | -122.388122739596 | (37.7657739601897, -122.388122739596) | 14 | 3 | 9 | 310 | 29 | ||||
10281 | 262560 | Undocumented 4 | Washingtonia robusta :: Mexican Fan Palm 72 | 1801 03rd St | 10 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6015928 | 2106803 | 37.7657739601897 | -122.388122739596 | (37.7657739601897, -122.388122739596) | 14 | 3 | 9 | 310 | 29 | ||||
15440 | 262565 | Undocumented 4 | Washingtonia robusta :: Mexican Fan Palm 72 | 1801 03rd St | 15 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6015928 | 2106803 | 37.7657739601897 | -122.388122739596 | (37.7657739601897, -122.388122739596) | 14 | 3 | 9 | 310 | 29 | ||||
15813 | 262563 | Undocumented 4 | Washingtonia robusta :: Mexican Fan Palm 72 | 1801 03rd St | 13 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6015928 | 2106803 | 37.7657739601897 | -122.388122739596 | (37.7657739601897, -122.388122739596) | 14 | 3 | 9 | 310 | 29 | ||||
15949 | 262561 | Undocumented 4 | Washingtonia robusta :: Mexican Fan Palm 72 | 1801 03rd St | 11 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6015928 | 2106803 | 37.7657739601897 | -122.388122739596 | (37.7657739601897, -122.388122739596) | 14 | 3 | 9 | 310 | 29 | ||||
16740 | 262573 | Undocumented 4 | Washingtonia robusta :: Mexican Fan Palm 72 | 1801 03rd St | 23 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6015928 | 2106803 | 37.7657739601897 | -122.388122739596 | (37.7657739601897, -122.388122739596) | 14 | 3 | 9 | 310 | 29 | ||||
17120 | 262555 | Undocumented 4 | Washingtonia robusta :: Mexican Fan Palm 72 | 1801 03rd St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6015928 | 2106803 | 37.7657739601897 | -122.388122739596 | (37.7657739601897, -122.388122739596) | 14 | 3 | 9 | 310 | 29 | ||||
18473 | 262562 | Undocumented 4 | Washingtonia robusta :: Mexican Fan Palm 72 | 1801 03rd St | 12 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6015928 | 2106803 | 37.7657739601897 | -122.388122739596 | (37.7657739601897, -122.388122739596) | 14 | 3 | 9 | 310 | 29 | ||||
18684 | 262572 | Undocumented 4 | Washingtonia robusta :: Mexican Fan Palm 72 | 1801 03rd St | 22 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6015928 | 2106803 | 37.7657739601897 | -122.388122739596 | (37.7657739601897, -122.388122739596) | 14 | 3 | 9 | 310 | 29 | ||||
133039 | 97497 | Undocumented 4 | Lyonothamnus floribundus subsp. asplenifolius :: Santa Cruz Ironwood 33 | 1520 Jerrold Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 03/03/2010 12:00:00 AM | 3 | 3x3 | 6015724.7 | 2096772.7 | 37.7382215976335 | -122.388125873954 | (37.7382215976335, -122.388125873954) | 10 | 3 | 8 | 58 | 1 | |
59753 | 104427 | Undocumented 4 | Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 42 | 1000x GILMAN AVE | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 20 | 4x4 | 6015570 | 2089525 | 37.71831228448 | -122.3881550967 | (37.71831228448, -122.3881550967) | 10 | 3 | 8 | 58 | 1 | |||
11056 | 111333 | Undocumented 4 | Quercus suber :: Cork Oak 78 | 698x ILLINOIS ST | 9 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6015875 | 2105932 | 37.7633794456224 | -122.388245263499 | (37.7633794456224, -122.388245263499) | 14 | 3 | 8 | 28856 | 29 | ||||
16757 | 111332 | Undocumented 4 | Quercus suber :: Cork Oak 78 | 698x ILLINOIS ST | 8 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6015875 | 2105932 | 37.7633794456224 | -122.388245263499 | (37.7633794456224, -122.388245263499) | 14 | 3 | 8 | 28856 | 29 | ||||
34139 | 111331 | Undocumented 4 | Quercus suber :: Cork Oak 78 | 698x ILLINOIS ST | 7 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6015875 | 2105932 | 37.7633794456224 | -122.388245263499 | (37.7633794456224, -122.388245263499) | 14 | 3 | 8 | 28856 | 29 | ||||
47021 | 111329 | Undocumented 4 | Quercus suber :: Cork Oak 78 | 698x ILLINOIS ST | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6015875 | 2105932 | 37.7633794456224 | -122.388245263499 | (37.7633794456224, -122.388245263499) | 14 | 3 | 8 | 28856 | 29 | ||||
63631 | 111325 | Undocumented 4 | Quercus suber :: Cork Oak 78 | 698x ILLINOIS ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6015875 | 2105932 | 37.7633794456224 | -122.388245263499 | (37.7633794456224, -122.388245263499) | 14 | 3 | 8 | 28856 | 29 | ||||
69479 | 111326 | Undocumented 4 | Quercus suber :: Cork Oak 78 | 698x ILLINOIS ST | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6015875 | 2105932 | 37.7633794456224 | -122.388245263499 | (37.7633794456224, -122.388245263499) | 14 | 3 | 8 | 28856 | 29 | ||||
87605 | 111327 | Undocumented 4 | Quercus suber :: Cork Oak 78 | 698x ILLINOIS ST | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6015875 | 2105932 | 37.7633794456224 | -122.388245263499 | (37.7633794456224, -122.388245263499) | 14 | 3 | 8 | 28856 | 29 | ||||
106469 | 111328 | Undocumented 4 | Quercus suber :: Cork Oak 78 | 698x ILLINOIS ST | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6015875 | 2105932 | 37.7633794456224 | -122.388245263499 | (37.7633794456224, -122.388245263499) | 14 | 3 | 8 | 28856 | 29 | ||||
169584 | 111330 | Undocumented 4 | Quercus suber :: Cork Oak 78 | 698x ILLINOIS ST | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6015875 | 2105932 | 37.7633794456224 | -122.388245263499 | (37.7633794456224, -122.388245263499) | 14 | 3 | 8 | 28856 | 29 | ||||
183272 | 96730 | Undocumented 4 | Koelreuteria paniculata :: Golden Rain Tree 131 | 1531 Jerrold Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | 3x3 | 6015658.7 | 2096702.1 | 37.738024087432 | -122.388349145132 | (37.738024087432, -122.388349145132) | 10 | 3 | 8 | 58 | 1 | |||
172772 | 107071 | Undocumented 4 | Tree(s) :: 17 | 400X MARIPOSA ST | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/01/2014 12:00:00 AM | 3 | 20x6 | Permit Number 773144 | 6015842 | 2106286 | 37.7643496247585 | -122.38838411004 | (37.7643496247585, -122.38838411004) | 14 | 3 | 8 | 28856 | 29 | |
85367 | 107721 | Undocumented 4 | Lophostemon confertus :: Brisbane Box 11 | 2690 03RD ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | 3x3 | Permit Number 774467 | 6015722.8 | 2103248.4 | 37.7560024194125 | -122.388584342965 | (37.7560024194125, -122.388584342965) | 10 | 3 | 8 | 28856 | 29 | ||
138329 | 200932 | Undocumented 4 | Tristania conferta :: 61 | 4101 03rd St | 7 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 0ft | 6015570.0337 | 2097446.6824 | 37.7400636451013 | -122.388707674257 | (37.7400636451013, -122.388707674257) | 10 | 3 | 8 | 58 | 1 | |||
159128 | 195219 | Undocumented 4 | Platanus x hispanica :: Sycamore: London Plane 27 | 750 Phelps St | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 21 | 6015588.9199 | 2098455.00002 | 37.7428333249904 | -122.388712743824 | (37.7428333249904, -122.388712743824) | 10 | 3 | 8 | 58 | 1 | ||||
50880 | 107396 | Undocumented 4 | Tree(s) :: 17 | 499X PHELPS ST | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6x6 | 6015581 | 2098395 | 37.7426681383468 | -122.38873594122 | (37.7426681383468, -122.38873594122) | 10 | 3 | 8 | 58 | 1 | ||||
116341 | 107398 | Undocumented 4 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 499X PHELPS ST | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6015581 | 2098395 | 37.7426681383468 | -122.38873594122 | (37.7426681383468, -122.38873594122) | 10 | 3 | 8 | 58 | 1 | |||||
121353 | 107397 | Undocumented 4 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 499X PHELPS ST | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6x6 | 6015581 | 2098395 | 37.7426681383468 | -122.38873594122 | (37.7426681383468, -122.38873594122) | 10 | 3 | 8 | 58 | 1 | ||||
138280 | 107395 | Undocumented 4 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 499X PHELPS ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6x6 | 6015581 | 2098395 | 37.7426681383468 | -122.38873594122 | (37.7426681383468, -122.38873594122) | 10 | 3 | 8 | 58 | 1 | ||||
80694 | 195220 | Undocumented 4 | Platanus x hispanica :: Sycamore: London Plane 27 | 750 Phelps St | 3 | Sidewalk: Property side : Yard | Tree | Private 2 | 10 | 6015550.34718 | 2098396.81359 | 37.7426714191664 | -122.388842057332 | (37.7426714191664, -122.388842057332) | 10 | 3 | 8 | 58 | 1 | ||||
72299 | 200142 | Undocumented 4 | Pinus Spp :: Pine Spp 100 | 700 Jamestown Ave | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 0ft | 6015325.0376 | 2088350.2198 | 37.7150729908419 | -122.388919862472 | (37.7150729908419, -122.388919862472) | 10 | 3 | 8 | 58 | 1 | |||
108657 | 107074 | Undocumented 4 | Tree(s) :: 17 | 1861X 03RD ST | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/01/2014 12:00:00 AM | 3 | 60x3 | Permit Number 773144 | 6015696 | 2106749 | 37.7656128312083 | -122.388921414698 | (37.7656128312083, -122.388921414698) | 14 | 3 | 9 | 310 | 29 | |
126168 | 107073 | Undocumented 4 | Tree(s) :: 17 | 1861X 03RD ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/01/2014 12:00:00 AM | 3 | 3x60 | Permit Number 773144 | 6015696 | 2106749 | 37.7656128312083 | -122.388921414698 | (37.7656128312083, -122.388921414698) | 14 | 3 | 9 | 310 | 29 | |
188742 | 107075 | Undocumented 4 | Tree(s) :: 17 | 1861 03RD ST | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/01/2014 12:00:00 AM | 3 | 60x3 | Permit Number 773144 | 6015696 | 2106749 | 37.7656128312083 | -122.388921414698 | (37.7656128312083, -122.388921414698) | 14 | 3 | 9 | 310 | 29 | |
115966 | 75904 | Undocumented 4 | Pyrus calleryana :: Ornamental Pear 44 | 25X Townsend St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/01/1996 12:00:00 AM | 3x3 | 6015812.3 | 2112596.8 | 37.7816760459871 | -122.388927462164 | (37.7816760459871, -122.388927462164) | 6 | 2 | 9 | 28856 | 20 | |||
162868 | 75932 | Undocumented 4 | Pyrus calleryana :: Ornamental Pear 44 | 25X Townsend St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/01/1996 12:00:00 AM | 5 | 3x3 | 6015812.3 | 2112596.8 | 37.7816760459871 | -122.388927462164 | (37.7816760459871, -122.388927462164) | 6 | 2 | 9 | 28856 | 20 | ||
34481 | 201714 | Undocumented 4 | Acacia stenophylla :: Shoestring Acacia 30 | 726 Jamestown Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 4ft | 6015317.96334 | 2088364.51894 | 37.7151118613908 | -122.388945312084 | (37.7151118613908, -122.388945312084) | 10 | 3 | 8 | 58 | 1 | |||
94518 | 191575 | Undocumented 4 | Lophostemon confertus :: Brisbane Box 11 | 750 Phelps St | 5 | : | Tree | Private 2 | 4 | Width 3ft | 6015519.38239 | 2098345.71066 | 37.7425293847338 | -122.388945558515 | (37.7425293847338, -122.388945558515) | 10 | 3 | 8 | 58 | 1 | |||
177971 | 200796 | Undocumented 4 | Pinus Spp :: Pine Spp 100 | 700 Jamestown Ave | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 0ft | 6015315.685 | 2088368.925 | 37.7151238332906 | -122.388953494511 | (37.7151238332906, -122.388953494511) | 10 | 3 | 8 | 58 | 1 | |||
76670 | 120566 | Undocumented 4 | Lophostemon confertus :: Brisbane Box 11 | 2190 03rd St | 8 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | 3x3 | 6015644 | 2105426 | 37.7619772765313 | -122.389008893863 | (37.7619772765313, -122.389008893863) | 10 | 3 | 8 | 28856 | 29 | |||
136176 | 120565 | Undocumented 4 | Lophostemon confertus :: Brisbane Box 11 | 2190 03rd St | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | 3x3 | 6015644 | 2105426 | 37.7619772765313 | -122.389008893863 | (37.7619772765313, -122.389008893863) | 10 | 3 | 8 | 28856 | 29 | |||
187338 | 120564 | Undocumented 4 | Lophostemon confertus :: Brisbane Box 11 | 2190 03rd St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | 3x3 | 6015644 | 2105426 | 37.7619772765313 | -122.389008893863 | (37.7619772765313, -122.389008893863) | 10 | 3 | 8 | 28856 | 29 | |||
148689 | 200798 | Undocumented 4 | Casuarina cunninghamiana :: Horsetail pine 112 | 700 Jamestown Ave | 7 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 0ft | 6015296.9798 | 2088405.4002 | 37.71522295028 | -122.389020693471 | (37.71522295028, -122.389020693471) | 10 | 3 | 8 | 58 | 1 | |||
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 | |||
160674 | 200336 | Undocumented 4 | Liriodendron tulipifera :: Tulip Tree 145 | 750 Phelps St | 8 | : | Tree | Private 2 | 9 | Width 3ft | 6015493.51667 | 2098314.62088 | 37.7424425848476 | -122.38903282511 | (37.7424425848476, -122.38903282511) | 10 | 3 | 8 | 58 | 1 | |||
26099 | 76191 | Undocumented 4 | Pyrus calleryana :: Ornamental Pear 44 | 49 Townsend St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/01/1996 12:00:00 AM | 12 | 3x3 | 6015772.4 | 2112409.7 | 37.7811600997206 | -122.389052431052 | (37.7811600997206, -122.389052431052) | 6 | 2 | 9 | 28856 | 20 | ||
37764 | 76002 | Undocumented 4 | Pyrus calleryana :: Ornamental Pear 44 | 49 Townsend St | 9 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/01/1996 12:00:00 AM | 9 | 3x3 | 6015772.4 | 2112409.7 | 37.7811600997206 | -122.389052431052 | (37.7811600997206, -122.389052431052) | 6 | 2 | 9 | 28856 | 20 | ||
42331 | 76087 | Undocumented 4 | Lophostemon confertus :: Brisbane Box 11 | 49 Townsend St | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/01/1996 12:00:00 AM | 9 | 3x3 | 6015772.4 | 2112409.7 | 37.7811600997206 | -122.389052431052 | (37.7811600997206, -122.389052431052) | 6 | 2 | 9 | 28856 | 20 | ||
50070 | 76136 | Undocumented 4 | Lophostemon confertus :: Brisbane Box 11 | 49 Townsend St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/01/1996 12:00:00 AM | 10 | 3x3 | 6015772.4 | 2112409.7 | 37.7811600997206 | -122.389052431052 | (37.7811600997206, -122.389052431052) | 6 | 2 | 9 | 28856 | 20 | ||
52319 | 76025 | Undocumented 4 | Lophostemon confertus :: Brisbane Box 11 | 49 Townsend St | 8 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/01/1996 12:00:00 AM | 9 | 3x4 | 6015772.4 | 2112409.7 | 37.7811600997206 | -122.389052431052 | (37.7811600997206, -122.389052431052) | 6 | 2 | 9 | 28856 | 20 | ||
57457 | 76057 | Undocumented 4 | Lophostemon confertus :: Brisbane Box 11 | 49 Townsend St | 7 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/01/1996 12:00:00 AM | 11 | 3x3 | 6015772.4 | 2112409.7 | 37.7811600997206 | -122.389052431052 | (37.7811600997206, -122.389052431052) | 6 | 2 | 9 | 28856 | 20 | ||
91018 | 76211 | Undocumented 4 | Lophostemon confertus :: Brisbane Box 11 | 49 Townsend St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/01/1996 12:00:00 AM | 10 | 4x4 | 6015772.4 | 2112409.7 | 37.7811600997206 | -122.389052431052 | (37.7811600997206, -122.389052431052) | 6 | 2 | 9 | 28856 | 20 | ||
92438 | 76165 | Undocumented 4 | Pyrus calleryana :: Ornamental Pear 44 | 49 Townsend St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/01/1996 12:00:00 AM | 6 | 3x3 | 6015772.4 | 2112409.7 | 37.7811600997206 | -122.389052431052 | (37.7811600997206, -122.389052431052) | 6 | 2 | 9 | 28856 | 20 | ||
125217 | 75960 | Undocumented 4 | Lophostemon confertus :: Brisbane Box 11 | 49 Townsend St | 10 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/01/1996 12:00:00 AM | 6 | 3x4 | 6015772.4 | 2112409.7 | 37.7811600997206 | -122.389052431052 | (37.7811600997206, -122.389052431052) | 6 | 2 | 9 | 28856 | 20 | ||
142439 | 76118 | Undocumented 4 | Lophostemon confertus :: Brisbane Box 11 | 49 Townsend St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/01/1996 12:00:00 AM | 12 | 3x3 | 6015772.4 | 2112409.7 | 37.7811600997206 | -122.389052431052 | (37.7811600997206, -122.389052431052) | 6 | 2 | 9 | 28856 | 20 | ||
180495 | 200337 | Undocumented 4 | Liriodendron tulipifera :: Tulip Tree 145 | 750 Phelps St | 9 | : | Tree | Private 2 | 10 | Width 4ft | 6015484.25752 | 2098301.13552 | 37.7424050435698 | -122.389063899405 | (37.7424050435698, -122.389063899405) | 10 | 3 | 8 | 58 | 1 | |||
25914 | 75352 | Undocumented 4 | Pittosporum undulatum :: Victorian Box 36 | 499 Illinois St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/15/2016 12:00:00 AM | 3 | 5x5 | 6015655 | 2107201 | 37.766851652402 | -122.389094788361 | (37.766851652402, -122.389094788361) | 14 | 3 | 9 | 310 | 29 | ||
142579 | 102543 | Undocumented 4 | Pittosporum undulatum :: Victorian Box 36 | 499 Illinois St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/15/2016 12:00:00 AM | 3 | 5x5 | 6015655 | 2107201 | 37.766851652402 | -122.389094788361 | (37.766851652402, -122.389094788361) | 14 | 3 | 9 | 310 | 29 | ||
149619 | 102542 | Undocumented 4 | Pittosporum undulatum :: Victorian Box 36 | 499 Illinois St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/15/2016 12:00:00 AM | 3 | 5x5 | 6015655 | 2107201 | 37.766851652402 | -122.389094788361 | (37.766851652402, -122.389094788361) | 14 | 3 | 9 | 310 | 29 | ||
152196 | 102544 | Undocumented 4 | Pittosporum undulatum :: Victorian Box 36 | 499 Illinois St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/15/2016 12:00:00 AM | 3 | 5x5 | 6015655 | 2107201 | 37.766851652402 | -122.389094788361 | (37.766851652402, -122.389094788361) | 14 | 3 | 9 | 310 | 29 | ||
176559 | 102541 | Undocumented 4 | Pittosporum undulatum :: Victorian Box 36 | 499 Illinois St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/15/2016 12:00:00 AM | 3 | 5x5 | 6015655 | 2107201 | 37.766851652402 | -122.389094788361 | (37.766851652402, -122.389094788361) | 14 | 3 | 9 | 310 | 29 | ||
63327 | 191576 | Undocumented 4 | Lophostemon confertus :: Brisbane Box 11 | 750 Phelps St | 10 | : | Tree | Private 2 | 3 | Width 4ft | 6015473.23648 | 2098286.93961 | 37.7423654535913 | -122.389101016203 | (37.7423654535913, -122.389101016203) | 10 | 3 | 8 | 58 | 1 | |||
8589 | 111310 | Undocumented 4 | Acacia spp :: Acacia Spp 105 | 99x GILROY ST | 1 | Unaccepted Street : Yard | Tree | Private 2 | 30x30 | 6015277 | 2088666 | 37.7159373992527 | -122.389107938034 | (37.7159373992527, -122.389107938034) | 10 | 3 | 8 | 58 | 1 | ||||
86119 | 111312 | Undocumented 4 | Acacia spp :: Acacia Spp 105 | 99x GILROY ST | 3 | Unaccepted Street : Yard | Tree | Private 2 | 30x30 | 6015277 | 2088666 | 37.7159373992527 | -122.389107938034 | (37.7159373992527, -122.389107938034) | 10 | 3 | 8 | 58 | 1 | ||||
89537 | 111311 | Undocumented 4 | Acacia spp :: Acacia Spp 105 | 99x GILROY ST | 2 | Unaccepted Street : Yard | Tree | Private 2 | 30x30 | 6015277 | 2088666 | 37.7159373992527 | -122.389107938034 | (37.7159373992527, -122.389107938034) | 10 | 3 | 8 | 58 | 1 | ||||
27429 | 116566 | Undocumented 4 | Lophostemon confertus :: Brisbane Box 11 | 1610 INNES AVE | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6015424 | 2097316 | 37.739696723386 | -122.38920348056 | (37.739696723386, -122.38920348056) | 10 | 3 | 8 | 58 | 1 | ||||
101852 | 116567 | Undocumented 4 | Lophostemon confertus :: Brisbane Box 11 | 1610 INNES AVE | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6015424 | 2097316 | 37.739696723386 | -122.38920348056 | (37.739696723386, -122.38920348056) | 10 | 3 | 8 | 58 | 1 | ||||
129180 | 116565 | Undocumented 4 | Lophostemon confertus :: Brisbane Box 11 | 1610 INNES AVE | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6015424 | 2097316 | 37.739696723386 | -122.38920348056 | (37.739696723386, -122.38920348056) | 10 | 3 | 8 | 58 | 1 | ||||
29167 | 121439 | Undocumented 4 | Washingtonia robusta :: Mexican Fan Palm 72 | 1750 03rd St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4x4 | 6015597 | 2107388 | 37.7673618983766 | -122.389308462256 | (37.7673618983766, -122.389308462256) | 14 | 3 | 9 | 310 | 20 | ||||
90115 | 121443 | Undocumented 4 | Washingtonia robusta :: Mexican Fan Palm 72 | 1750 03rd St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4x4 | 6015597 | 2107388 | 37.7673618983766 | -122.389308462256 | (37.7673618983766, -122.389308462256) | 14 | 3 | 9 | 310 | 20 | ||||
125105 | 121442 | Undocumented 4 | Washingtonia robusta :: Mexican Fan Palm 72 | 1750 03rd St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4x4 | 6015597 | 2107388 | 37.7673618983766 | -122.389308462256 | (37.7673618983766, -122.389308462256) | 14 | 3 | 9 | 310 | 20 | ||||
133893 | 121441 | Undocumented 4 | Washingtonia robusta :: Mexican Fan Palm 72 | 1750 03rd St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4x4 | 6015597 | 2107388 | 37.7673618983766 | -122.389308462256 | (37.7673618983766, -122.389308462256) | 14 | 3 | 9 | 310 | 20 | ||||
135017 | 121440 | Undocumented 4 | Washingtonia robusta :: Mexican Fan Palm 72 | 1750 03rd St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4x4 | 6015597 | 2107388 | 37.7673618983766 | -122.389308462256 | (37.7673618983766, -122.389308462256) | 14 | 3 | 9 | 310 | 20 | ||||
43652 | 116560 | Undocumented 4 | Lophostemon confertus :: Brisbane Box 11 | 1620 INNES AVE | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6015376 | 2097346 | 37.7397764361483 | -122.389371539928 | (37.7397764361483, -122.389371539928) | 10 | 3 | 8 | 58 | 1 | ||||
76585 | 116562 | Undocumented 4 | Lophostemon confertus :: Brisbane Box 11 | 1620 INNES AVE | 8 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6015376 | 2097346 | 37.7397764361483 | -122.389371539928 | (37.7397764361483, -122.389371539928) | 10 | 3 | 8 | 58 | 1 | ||||
100133 | 116555 | Undocumented 4 | Lophostemon confertus :: Brisbane Box 11 | 1620 INNES AVE | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6015376 | 2097346 | 37.7397764361483 | -122.389371539928 | (37.7397764361483, -122.389371539928) | 10 | 3 | 8 | 58 | 1 | ||||
100672 | 116561 | Undocumented 4 | Lophostemon confertus :: Brisbane Box 11 | 1620 INNES AVE | 7 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6015376 | 2097346 | 37.7397764361483 | -122.389371539928 | (37.7397764361483, -122.389371539928) | 10 | 3 | 8 | 58 | 1 | ||||
116789 | 116564 | Undocumented 4 | Lophostemon confertus :: Brisbane Box 11 | 1620 INNES AVE | 10 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6015376 | 2097346 | 37.7397764361483 | -122.389371539928 | (37.7397764361483, -122.389371539928) | 10 | 3 | 8 | 58 | 1 | ||||
117575 | 116563 | Undocumented 4 | Lophostemon confertus :: Brisbane Box 11 | 1620 INNES AVE | 9 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6015376 | 2097346 | 37.7397764361483 | -122.389371539928 | (37.7397764361483, -122.389371539928) | 10 | 3 | 8 | 58 | 1 | ||||
130782 | 116559 | Undocumented 4 | Lophostemon confertus :: Brisbane Box 11 | 1620 INNES AVE | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6015376 | 2097346 | 37.7397764361483 | -122.389371539928 | (37.7397764361483, -122.389371539928) | 10 | 3 | 8 | 58 | 1 | ||||
154399 | 116558 | Undocumented 4 | Lophostemon confertus :: Brisbane Box 11 | 1620 INNES AVE | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6015376 | 2097346 | 37.7397764361483 | -122.389371539928 | (37.7397764361483, -122.389371539928) | 10 | 3 | 8 | 58 | 1 | ||||
159808 | 116557 | Undocumented 4 | Lophostemon confertus :: Brisbane Box 11 | 1620 INNES AVE | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6015376 | 2097346 | 37.7397764361483 | -122.389371539928 | (37.7397764361483, -122.389371539928) | 10 | 3 | 8 | 58 | 1 | ||||
178868 | 116556 | Undocumented 4 | Lophostemon confertus :: Brisbane Box 11 | 1620 INNES AVE | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6015376 | 2097346 | 37.7397764361483 | -122.389371539928 | (37.7397764361483, -122.389371539928) | 10 | 3 | 8 | 58 | 1 | ||||
52665 | 254470 | Undocumented 4 | Populus nigra 'Italica' :: Lombardy Poplar 59 | 1601 Evans Ave | 11 | Sidewalk: Property side : Yard | Tree | Private 2 | 3x3 | 6015397 | 2098706 | 37.7435118805521 | -122.389393878977 | (37.7435118805521, -122.389393878977) | 10 | 3 | 8 | 58 | 1 | ||||
61959 | 254462 | Undocumented 4 | Lophostemon confertus :: Brisbane Box 11 | 1601 Evans Ave | 56 | Sidewalk: Curb side : Yard | Tree | Private 2 | 3x3 | 6015397 | 2098706 | 37.7435118805521 | -122.389393878977 | (37.7435118805521, -122.389393878977) | 10 | 3 | 8 | 58 | 1 | ||||
90453 | 254461 | Undocumented 4 | Lophostemon confertus :: Brisbane Box 11 | 1601 Evans Ave | 55 | Sidewalk: Curb side : Yard | Tree | Private 2 | 3x3 | 6015397 | 2098706 | 37.7435118805521 | -122.389393878977 | (37.7435118805521, -122.389393878977) | 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) );