Data source: data.sfgov.org
This data as json, CSV (advanced)
Link | rowid | TreeID | qLegalStatus | qSpecies | qAddress | SiteOrder | qSiteInfo | PlantType | qCaretaker | qCareAssistant | PlantDate | DBH | PlotSize | PermitNotes | XCoord | YCoord | Latitude | Longitude ▼ | Location |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
45296 | 45296 | 248254 | Undocumented 2 | Ceratonia siliqua :: Carob 97 | 112 Lundy's Ln | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 13 | Width 3ft | 6006798.65634 | 2098892.16282 | 37.7435425780247 | -122.419138073069 | (37.7435425780247, -122.419138073069) | |||
176531 | 176531 | 248253 | Undocumented 2 | Ceratonia siliqua :: Carob 97 | 112 Lundy's Ln | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 14 | Width 3ft | 6006804.331590001 | 2098902.21261 | 37.7435704920937 | -122.419119162122 | (37.7435704920937, -122.419119162122) | |||
113525 | 113525 | 113693 | Undocumented 2 | Ceratonia siliqua :: Carob 97 | 112 LUNDYS LN | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x5 | 6006814.0 | 2098928.0 | 37.7436418429474 | -122.419087559811 | (37.7436418429474, -122.419087559811) | ||||
144112 | 144112 | 113692 | Undocumented 2 | Ceratonia siliqua :: Carob 97 | 112 LUNDYS LN | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 14 | 3x3 | 6006814.0 | 2098928.0 | 37.7436418429474 | -122.419087559811 | (37.7436418429474, -122.419087559811) | |||
33356 | 33356 | 248279 | Undocumented 2 | Ceratonia siliqua :: Carob 97 | 111 Lundy's Ln | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 13 | Width 3ft | 6006822.34586 | 2098891.67697 | 37.743542578041 | -122.419056125953 | (37.743542578041, -122.419056125953) | |||
93830 | 93830 | 63116 | Permitted Site 1 | Ceratonia siliqua :: Carob 97 | 115 Lundy's Ln | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/08/1986 12:00:00 AM | Permit Number 23622 | 6006844.85682717 | 2098899.69149034 | 37.7435658517454 | -122.41897885676701 | (37.7435658517454, -122.418978856767) | ||
85788 | 85788 | 57557 | Permitted Site 1 | Ceratonia siliqua :: Carob 97 | 88 LUNDYS LN | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/26/1976 12:00:00 AM | 8 | 3x3 | Permit Number 16422 | 6006885.0 | 2099070.0 | 37.744035741100504 | -122.418852127392 | (37.7440357411005, -122.418852127392) | |
86972 | 86972 | 58315 | Permitted Site 1 | Ceratonia siliqua :: Carob 97 | 86 Lundy's Ln | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/08/1986 12:00:00 AM | Permit Number 23623 | 6006886.31504247 | 2099084.89744452 | 37.744076720184495 | -122.41884863660299 | (37.7440767201845, -122.418848636603) | ||
65181 | 65181 | 248195 | Undocumented 2 | Ceratonia siliqua :: Carob 97 | 99 Lundy's Ln | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 3ft | 6006895.3062 | 2099022.5140400003 | 37.7439059356157 | -122.418813123741 | (37.7439059356157, -122.418813123741) | |||
32338 | 32338 | 248196 | Undocumented 2 | Ceratonia siliqua :: Carob 97 | 99 Lundy's Ln | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | Width 3ft | 6006902.26536 | 2099037.70953 | 37.7439480508589 | -122.41879013796101 | (37.7439480508589, -122.418790137961) | |||
43078 | 43078 | 248232 | Undocumented 2 | Ceratonia siliqua :: Carob 97 | 86 Lundy's Ln | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | Width 2ft | 6006910.04538 | 2099108.75258 | 37.744143557179896 | -122.41876827364901 | (37.7441435571799, -122.418768273649) | |||
152658 | 152658 | 248198 | Undocumented 2 | Ceratonia siliqua :: Carob 97 | 57 Lundy's Ln | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 15 | Width 3ft | 6006917.65895 | 2099068.8782900004 | 37.744034500003295 | -122.418739120308 | (37.7440345000033, -122.418739120308) | |||
184060 | 184060 | 248231 | Undocumented 2 | Ceratonia siliqua :: Carob 97 | 80 Lundy's Ln | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11 | Width 3ft | 6006921.48329 | 2099128.86154 | 37.74419941586729 | -122.41873014957599 | (37.7441994158673, -122.418730149576) | |||
81764 | 81764 | 63117 | Permitted Site 1 | Ceratonia siliqua :: Carob 97 | 72 Lundy's Ln | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/08/1986 12:00:00 AM | Permit Number 23624 | 6006928.92708318 | 2099162.96302102 | 37.7442934699851 | -122.418706828381 | (37.7442934699851, -122.418706828381) | ||
181222 | 181222 | 248199 | Undocumented 2 | Ceratonia siliqua :: Carob 97 | 55 Lundy's Ln | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11 | Width 3ft | 6006933.20129 | 2099091.48631 | 37.7440974516285 | -122.41868698121999 | (37.7440974516285, -122.41868698122) | |||
107534 | 107534 | 63118 | Permitted Site 1 | Ceratonia siliqua :: Carob 97 | 70 Lundy's Ln | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/08/1986 12:00:00 AM | Permit Number 23625 | 6006935.01451866 | 2099174.11524824 | 37.7443244342333 | -122.418686569992 | (37.7443244342333, -122.418686569992) | ||
185308 | 185308 | 248230 | Undocumented 2 | Ceratonia siliqua :: Carob 97 | 74 Lundy's Ln | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | Width 3ft | 6006935.57349 | 2099151.82262 | 37.7442632551522 | -122.418683056597 | (37.7442632551522, -122.418683056597) | |||
55143 | 55143 | 248200 | Undocumented 2 | Ceratonia siliqua :: Carob 97 | 53 Lundy's Ln | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 3ft | 6006940.782319999 | 2099105.37762 | 37.744136020872205 | -122.418661752548 | (37.7441360208722, -122.418661752548) | |||
149673 | 149673 | 248229 | Undocumented 2 | Ceratonia siliqua :: Carob 97 | 72 Lundy's Ln | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | Width 3ft | 6006943.33301 | 2099166.5172900003 | 37.7443040402894 | -122.41865726764401 | (37.7443040402894, -122.418657267644) | |||
65155 | 65155 | 248201 | Undocumented 2 | Ceratonia siliqua :: Carob 97 | 53 Lundy's Ln | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | Width 3ft | 6006949.2101 | 2099121.02775 | 37.7441794671077 | -122.41863372066601 | (37.7441794671077, -122.418633720666) | |||
40106 | 40106 | 248228 | Undocumented 2 | Ceratonia siliqua :: Carob 97 | 70 Lundy's Ln | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | Width 3ft | 6006955.04848 | 2099184.3603 | 37.744353692775995 | -122.41861802300501 | (37.744353692776, -122.418618023005) | |||
176629 | 176629 | 248202 | Undocumented 2 | Ceratonia siliqua :: Carob 97 | 51 Lundy's Ln | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | Width 3ft | 6006954.7875 | 2099136.48348 | 37.7442222190818 | -122.418615530989 | (37.7442222190818, -122.418615530989) | |||
137669 | 137669 | 248203 | Undocumented 2 | Ceratonia siliqua :: Carob 97 | 47 Lundy's Ln | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 3ft | 6006976.18023 | 2099171.17204 | 37.7443186704674 | -122.418544018687 | (37.7443186704674, -122.418544018687) | |||
149968 | 149968 | 248204 | Undocumented 2 | Ceratonia siliqua :: Carob 97 | 47 Lundy's Ln | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 3ft | 6006982.897919999 | 2099182.4975099997 | 37.744350145854796 | -122.418521593214 | (37.7443501458548, -122.418521593214) | |||
75887 | 75887 | 225065 | Undocumented 2 | Ceratonia siliqua :: Carob 97 | 219 Bonview St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 3ft | 6006960.17815 | 2097772.4528099997 | 37.740477199257704 | -122.418500188445 | (37.7404771992577, -122.418500188445) | |||
143717 | 143717 | 63120 | Permitted Site 1 | Ceratonia siliqua :: Carob 97 | 46 Lundy's Ln | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/09/1986 12:00:00 AM | Permit Number 23631 | 6007008.06371762 | 2099307.94192573 | 37.7446960047915 | -122.418443468102 | (37.7446960047915, -122.418443468102) | ||
144535 | 144535 | 63125 | Permitted Site 1 | Ceratonia siliqua :: Carob 97 | 80 Prospect Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/09/1986 12:00:00 AM | Permit Number 23639 | 6007006.19001516 | 2099063.67894521 | 37.744025207978 | -122.418432630519 | (37.744025207978, -122.418432630519) | ||
138411 | 138411 | 63122 | Permitted Site 1 | Ceratonia siliqua :: Carob 97 | 42 Lundy's Ln | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 08/26/1993 12:00:00 AM | Permit Number 32290 | 6007020.23858667 | 2099330.24637666 | 37.7447579331798 | -122.41840295087499 | (37.7447579331798, -122.418402950875) | ||
123961 | 123961 | 57556 | Permitted Site 1 | Ceratonia siliqua :: Carob 97 | 57 Lundy's Ln | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/08/1986 12:00:00 AM | Permit Number 23627 | 6007019.50965831 | 2099220.3784742 | 37.7444562195491 | -122.418397682663 | (37.7444562195491, -122.418397682663) | ||
82535 | 82535 | 63222 | Permitted Site 1 | Ceratonia siliqua :: Carob 97 | 76 Prospect Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/06/1987 12:00:00 AM | Permit Number 23766 | 6007018.22684623 | 2099086.03719365 | 37.7440872763149 | -122.41839259476801 | (37.7440872763149, -122.418392594768) | ||
70040 | 70040 | 248206 | Undocumented 2 | Ceratonia siliqua :: Carob 97 | 39 Lundy's Ln | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 3ft | 6007021.99675 | 2099262.74695 | 37.744572693881395 | -122.41839208633999 | (37.7445726938814, -122.41839208634) | |||
172679 | 172679 | 248207 | Undocumented 2 | Ceratonia siliqua :: Carob 97 | 39 Lundy's Ln | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 3ft | 6007026.812390001 | 2099268.29908 | 37.7445882098712 | -122.41837582837601 | (37.7445882098712, -122.418375828376) | |||
124706 | 124706 | 63223 | Permitted Site 1 | Ceratonia siliqua :: Carob 97 | 74 Prospect Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 11/08/1986 12:00:00 AM | Permit Number 23767 | 6007024.24525419 | 2099097.21630379 | 37.7441183104389 | -122.418372576893 | (37.7441183104389, -122.418372576893) | ||
127474 | 127474 | 63232 | Permitted Site 1 | Ceratonia siliqua :: Carob 97 | 53 Lundy's Ln | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/13/1987 12:00:00 AM | Permit Number 23779 | 6007031.32644483 | 2099242.02691528 | 37.7445163265111 | -122.418358357204 | (37.7445163265111, -122.418358357204) | ||
64383 | 64383 | 248208 | Undocumented 2 | Ceratonia siliqua :: Carob 97 | 37 Lundy's Ln | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 3ft | 6007034.71089 | 2099281.8609599997 | 37.744625892375396 | -122.41834947827101 | (37.7446258923754, -122.418349478271) | |||
84450 | 84450 | 51842 | Permitted Site 1 | Ceratonia siliqua :: Carob 97 | 34 Lundy's Ln | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/09/1986 12:00:00 AM | Permit Number 48069 | 6007044.58832094 | 2099374.8552715 | 37.7448817898933 | -122.41832191623199 | (37.7448817898933, -122.418321916232) | ||
150639 | 150639 | 248209 | Undocumented 2 | Ceratonia siliqua :: Carob 97 | 37 Lundy's Ln | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | Width 3ft | 6007043.43628 | 2099296.21325 | 37.7446657917085 | -122.418320324941 | (37.7446657917085, -122.418320324941) | |||
120646 | 120646 | 63121 | Permitted Site 1 | Ceratonia siliqua :: Carob 97 | 42 Prospect Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/09/1986 12:00:00 AM | Permit Number 23632 | 6007120.53987433 | 2099276.08223849 | 37.7446148564174 | -122.418052288309 | (37.7446148564174, -122.418052288309) | ||
66191 | 66191 | 48531 | Permitted Site 1 | Ceratonia siliqua :: Carob 97 | 500(REVISED) Capp St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 08/22/2002 12:00:00 AM | Permit Number 45857 | 6007225.9541014 | 2104383.62172477 | 37.7586449307205 | -122.41804980128 | (37.7586449307205, -122.41804980128) | |||
88250 | 88250 | 48533 | Permitted Site 1 | Ceratonia siliqua :: Carob 97 | 500(REVISED) Capp St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 08/22/2002 12:00:00 AM | Permit Number 45857 | 6007225.9541014 | 2104383.62172477 | 37.7586449307205 | -122.41804980128 | (37.7586449307205, -122.41804980128) | |||
138752 | 138752 | 48532 | Permitted Site 1 | Ceratonia siliqua :: Carob 97 | 500(REVISED) Capp St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 08/22/2002 12:00:00 AM | Permit Number 45857 | 6007225.9541014 | 2104383.62172477 | 37.7586449307205 | -122.41804980128 | (37.7586449307205, -122.41804980128) | |||
84256 | 84256 | 63130 | Permitted Site 1 | Ceratonia siliqua :: Carob 97 | 26 Prospect Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/11/1986 12:00:00 AM | Permit Number 23644 | 6007187.15982152 | 2099399.82780325 | 37.7449583833589 | -122.417830699083 | (37.7449583833589, -122.417830699083) | ||
102430 | 102430 | 96852 | Undocumented 2 | Ceratonia siliqua :: Carob 97 | 1x Bennington St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | 3x3 | 6007194.0 | 2097789.0 | 37.7405357947447 | -122.417692894396 | (37.7405357947447, -122.417692894396) | |||
120289 | 120289 | 96855 | Undocumented 2 | Ceratonia siliqua :: Carob 97 | 600 Eugenia Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | 3x3 | 6007257.0 | 2097738.0 | 37.740399305054005 | -122.41747145076599 | (37.740399305054, -122.417471450766) | |||
51934 | 51934 | 225074 | Undocumented 2 | Ceratonia siliqua :: Carob 97 | 3354 25th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 20 | Width 3ft | 6007335.7626 | 2101504.20622 | 37.750744893976204 | -122.417465967185 | (37.7507448939762, -122.417465967185) | |||
71925 | 71925 | 126003 | Undocumented 2 | Ceratonia siliqua :: Carob 97 | 2510 Jones St | 8 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 19 | Width 4ft | 6007892.3710199995 | 2121599.81603 | 37.80595393089521 | -122.41696482266501 | (37.8059539308952, -122.416964822665) | |||
28181 | 28181 | 126002 | Undocumented 2 | Ceratonia siliqua :: Carob 97 | 2510 Jones St | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11 | Width 4ft | 6007897.34981 | 2121579.9870599997 | 37.805899765629704 | -122.41694618692699 | (37.8058997656297, -122.416946186927) | |||
61924 | 61924 | 126001 | Undocumented 2 | Ceratonia siliqua :: Carob 97 | 2510 Jones St | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 16 | Width 4ft | 6007899.07258 | 2121560.79928 | 37.8058471777553 | -122.41693886466001 | (37.8058471777553, -122.41693886466) | |||
23831 | 23831 | 126000 | Undocumented 2 | Ceratonia siliqua :: Carob 97 | 2510 Jones St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 14 | Width 4ft | 6007902.73328 | 2121542.33791 | 37.805796693425705 | -122.41692488738501 | (37.8057966934257, -122.416924887385) | |||
70834 | 70834 | 125999 | Undocumented 2 | Ceratonia siliqua :: Carob 97 | 2510 Jones St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 4ft | 6007905.9664 | 2121521.7786 | 37.8057404246312 | -122.41691224110399 | (37.8057404246312, -122.416912241104) | |||
180722 | 180722 | 125998 | Undocumented 2 | Ceratonia siliqua :: Carob 97 | 2510 Jones St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 18 | Width 4ft | 6007907.02571 | 2121498.39071 | 37.8056762669961 | -122.416906917118 | (37.8056762669961, -122.416906917118) | |||
67137 | 67137 | 125997 | Undocumented 2 | Ceratonia siliqua :: Carob 97 | 2510 Jones St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | Width 4ft | 6007910.60432 | 2121475.9089200003 | 37.8056147389887 | -122.416892938958 | (37.8056147389887, -122.416892938958) | |||
60413 | 60413 | 125996 | Undocumented 2 | Ceratonia siliqua :: Carob 97 | 2510 Jones St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 16 | Width 4ft | 6007913.10752 | 2121457.27998 | 37.8055637294392 | -122.41688295558001 | (37.8055637294392, -122.41688295558) | |||
178393 | 178393 | 225075 | Undocumented 2 | Ceratonia siliqua :: Carob 97 | 3334 25th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 3ft | 6007507.05129 | 2101513.0888099996 | 37.750778919809 | -122.416874263658 | (37.750778919809, -122.416874263658) | |||
72501 | 72501 | 225044 | Undocumented 2 | Ceratonia siliqua :: Carob 97 | 15 Winfield St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 3ft | 6007468.43971 | 2099454.94472 | 37.7451255476034 | -122.4168619861 | (37.7451255476034, -122.4168619861) | |||
45627 | 45627 | 225076 | Undocumented 2 | Ceratonia siliqua :: Carob 97 | 3328 25th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11 | Width 3ft | 6007533.56344 | 2101516.4180900003 | 37.7507895524966 | -122.41678281788602 | (37.7507895524966, -122.416782817886) | |||
145872 | 145872 | 63270 | Permitted Site 1 | Ceratonia siliqua :: Carob 97 | 15 Winfield St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/26/1987 12:00:00 AM | Permit Number 23827 | 6007494.42657363 | 2099465.13084364 | 37.7451549781049 | -122.41677284932 | (37.7451549781049, -122.41677284932) | ||
4768 | 4768 | 188475 | Undocumented 2 | Ceratonia siliqua :: Carob 97 | 255 12th St | 10 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 13 | Width 5ft | 6007904.0486 | 2109028.3939900002 | 37.7714365370061 | -122.41603356660299 | (37.7714365370061, -122.416033566603) | |||
89537 | 89537 | 21785 | DPW Maintained 3 | Ceratonia siliqua :: Carob 97 | 2585 Taylor St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 4X4 | 6008161.90241 | 2121549.7946200003 | 37.8058317424248 | -122.41602851933997 | (37.8058317424248, -122.41602851934) | |||
126575 | 126575 | 21789 | DPW Maintained 3 | Ceratonia siliqua :: Carob 97 | 2585 Taylor St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 05/20/2015 12:00:00 AM | 3 | 4X4 | 6008161.90241 | 2121549.7946200003 | 37.8058317424248 | -122.41602851933997 | (37.8058317424248, -122.41602851934) | ||
4816 | 4816 | 188474 | Undocumented 2 | Ceratonia siliqua :: Carob 97 | 255 12th St | 9 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 5ft | 6007923.258880001 | 2109012.80714 | 37.7713948192467 | -122.41596601311599 | (37.7713948192467, -122.415966013116) | |||
151813 | 151813 | 51298 | Permitted Site 1 | Ceratonia siliqua :: Carob 97 | 300X Golden Gate Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 09/07/2004 12:00:00 AM | 7 | Permit Number 47670 | 6008009.38054 | 2112753.19289 | 37.7816698695126 | -122.415933029587 | (37.7816698695126, -122.415933029587) | |
4806 | 4806 | 188473 | Undocumented 2 | Ceratonia siliqua :: Carob 97 | 255 12th St | 8 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 25 | Width 5ft | 6007942.65601 | 2109006.33264 | 37.771378132318894 | -122.415898458759 | (37.7713781323189, -122.415898458759) | |||
4762 | 4762 | 188472 | Undocumented 2 | Ceratonia siliqua :: Carob 97 | 255 12th St | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 5ft | 6007955.34249 | 2108999.99523 | 37.7713614445082 | -122.41585412666099 | (37.7713614445082, -122.415854126661) | |||
159567 | 159567 | 51299 | Permitted Site 1 | Ceratonia siliqua :: Carob 97 | 300X Golden Gate Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 09/07/2004 12:00:00 AM | 10 | Permit Number 47670 | 6008033.00976 | 2112757.64367 | 37.781683418708404 | -122.415851598691 | (37.7816834187084, -122.415851598691) | |
72094 | 72094 | 51302 | Permitted Site 1 | Ceratonia siliqua :: Carob 97 | 300X Golden Gate Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 09/07/2004 12:00:00 AM | 12 | Permit Number 47670 | 6008052.8861 | 2112760.32075 | 37.781691886721795 | -122.415783025366 | (37.7816918867218, -122.415783025366) | |
105938 | 105938 | 51301 | Permitted Site 1 | Ceratonia siliqua :: Carob 97 | 101 Hyde St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 11/20/2004 12:00:00 AM | Permit Number 47670 | 6008105.70875607 | 2112751.56982087 | 37.7816708281319 | -122.41559966360799 | (37.7816708281319, -122.415599663608) | ||
4779 | 4779 | 188471 | Undocumented 2 | Ceratonia siliqua :: Carob 97 | 255 12th St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 15 | Width 5ft | 6008055.90153 | 2108933.51614 | 37.7711845613454 | -122.41550157982799 | (37.7711845613454, -122.415501579828) | |||
174828 | 174828 | 125988 | Undocumented 2 | Ceratonia siliqua :: Carob 97 | 2361 Taylor St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | Width 3ft | 6008319.39655 | 2121673.00017 | 37.806178887323 | -122.41549221341101 | (37.806178887323, -122.415492213411) | |||
160878 | 160878 | 125989 | Undocumented 2 | Ceratonia siliqua :: Carob 97 | 2361 Taylor St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | Width 3ft | 6008326.45195 | 2121634.40634 | 37.8060733149832 | -122.41546506288 | (37.8060733149832, -122.41546506288) | |||
122387 | 122387 | 65950 | Permitted Site 1 | Ceratonia siliqua :: Carob 97 | 120 Hyde St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/04/1990 12:00:00 AM | Permit Number 28971 | 6008148.07854497 | 2112823.994523 | 37.7818720705068 | -122.415458212735 | (37.7818720705068, -122.415458212735) | ||
34241 | 34241 | 125971 | Undocumented 2 | Ceratonia siliqua :: Carob 97 | 100 Hyde St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 19 | Width 4ft | 6008148.4886 | 2112831.1491900003 | 37.7818917385495 | -122.415457300812 | (37.7818917385495, -122.415457300812) | |||
90047 | 90047 | 21787 | Permitted Site 1 | Ceratonia siliqua :: Carob 97 | 2585 Taylor St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | 4X4 | 6008331.30284 | 2121636.25204 | 37.806078655460894 | -122.41544840628201 | (37.8060786554609, -122.415448406282) | |||
4765 | 4765 | 188470 | Undocumented 2 | Ceratonia siliqua :: Carob 97 | 255 12th St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 20 | Width 5ft | 6008074.61393 | 2108923.40936 | 37.7711578622784 | -122.415436137088 | (37.7711578622784, -122.415436137088) | |||
57395 | 57395 | 125990 | Undocumented 2 | Ceratonia siliqua :: Carob 97 | 2361 Taylor St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | Width 3ft | 6008335.581590001 | 2121584.4344900004 | 37.8059366180507 | -122.415429928145 | (37.8059366180507, -122.415429928145) | |||
25271 | 25271 | 125991 | Undocumented 2 | Ceratonia siliqua :: Carob 97 | 2361 Taylor St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11 | Width 3ft | 6008338.82398 | 2121554.9566599997 | 37.805855861614795 | -122.41541661910699 | (37.8058558616148, -122.415416619107) | |||
174972 | 174972 | 125992 | Undocumented 2 | Ceratonia siliqua :: Carob 97 | 2361 Taylor St | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | Width 3ft | 6008341.11218 | 2121531.47257 | 37.8057915088426 | -122.41540703681801 | (37.8057915088426, -122.415407036818) | |||
88163 | 88163 | 21790 | Permitted Site 1 | Ceratonia siliqua :: Carob 97 | 2585 Taylor St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | 4X4 | 6008342.51156 | 2121554.8602 | 37.8058558040212 | -122.41540385079901 | (37.8058558040212, -122.415403850799) | |||
4814 | 4814 | 188469 | Undocumented 2 | Ceratonia siliqua :: Carob 97 | 255 12th St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 5ft | 6008084.262680001 | 2108917.7420900003 | 37.771142843604004 | -122.41540236032499 | (37.771142843604, -122.415402360325) | |||
137305 | 137305 | 125993 | Undocumented 2 | Ceratonia siliqua :: Carob 97 | 2361 Taylor St | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | Width 3ft | 6008342.4716300005 | 2121500.19485 | 37.8057057045282 | -122.415400116539 | (37.8057057045282, -122.415400116539) | |||
18910 | 18910 | 21791 | Permitted Site 1 | Ceratonia siliqua :: Carob 97 | 2585 Taylor St | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | 4X4 | 6008347.28278 | 2121527.17705 | 37.8057800612465 | -122.41538537817499 | (37.8057800612465, -122.415385378175) | |||
188434 | 188434 | 125994 | Undocumented 2 | Ceratonia siliqua :: Carob 97 | 2361 Taylor St | 8 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | Width 3ft | 6008347.52133 | 2121476.34798 | 37.805640510859206 | -122.41538095198901 | (37.8056405108592, -122.415380951989) | |||
115904 | 115904 | 21786 | Permitted Site 1 | Ceratonia siliqua :: Carob 97 | 2585 Taylor St | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | 4X4 | 6008350.54359 | 2121501.89618 | 37.805710829631295 | -122.41537230277201 | (37.8057108296313, -122.415372302772) | |||
67946 | 67946 | 125995 | Undocumented 2 | Ceratonia siliqua :: Carob 97 | 2361 Taylor St | 9 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | Width 3ft | 6008349.66203 | 2121453.17315 | 37.8055769989413 | -122.41537190211201 | (37.8055769989413, -122.415371902112) | |||
4810 | 4810 | 188468 | Undocumented 2 | Ceratonia siliqua :: Carob 97 | 255 12th St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 17 | Width 5ft | 6008096.35172 | 2108912.02487 | 37.7711278249234 | -122.415360138963 | (37.7711278249234, -122.415360138963) | |||
84621 | 84621 | 21779 | Permitted Site 1 | Ceratonia siliqua :: Carob 97 | 2535 Taylor St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | 4x4 | 6008355.3148 | 2121474.2130400003 | 37.8056350868765 | -122.415353830252 | (37.8056350868765, -122.415353830252) | |||
86378 | 86378 | 21780 | Permitted Site 1 | Ceratonia siliqua :: Carob 97 | 2535 Taylor St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | 4X4 | 6008357.89402 | 2121452.8869 | 37.805576675639 | -122.41534339379 | (37.805576675639, -122.41534339379) | |||
4791 | 4791 | 188467 | Undocumented 2 | Ceratonia siliqua :: Carob 97 | 255 12th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 14 | Width 5ft | 6008105.3532300005 | 2108904.54782 | 37.77110780062 | -122.415328472924 | (37.77110780062, -122.415328472924) | |||
56220 | 56220 | 125987 | Undocumented 2 | Ceratonia siliqua :: Carob 97 | 2362 Taylor St | 8 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 14 | Width 6ft | 6008367.52131 | 2121686.8739 | 37.8062196859398 | -122.415326651828 | (37.8062196859398, -122.415326651828) | |||
44097 | 44097 | 125986 | Undocumented 2 | Ceratonia siliqua :: Carob 97 | 2362 Taylor St | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 19 | Width 6ft | 6008368.52895 | 2121668.4711599997 | 37.8061692132974 | -122.415321861121 | (37.8061692132974, -122.415321861121) | |||
40966 | 40966 | 125985 | Undocumented 2 | Ceratonia siliqua :: Carob 97 | 2362 Taylor St | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 16 | Width 6ft | 6008371.27829 | 2121652.4837 | 37.8061254702907 | -122.415311214049 | (37.8061254702907, -122.415311214049) | |||
52501 | 52501 | 125984 | Undocumented 2 | Ceratonia siliqua :: Carob 97 | 2362 Taylor St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 18 | Width 6ft | 6008373.73288 | 2121637.11508 | 37.8060834098955 | -122.41530163086 | (37.8060834098955, -122.41530163086) | |||
136532 | 136532 | 125983 | Undocumented 2 | Ceratonia siliqua :: Carob 97 | 2362 Taylor St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 14 | Width 5ft | 6008377.32314 | 2121617.1276 | 37.8060287311026 | -122.415287790321 | (37.8060287311026, -122.415287790321) | |||
136904 | 136904 | 125982 | Undocumented 2 | Ceratonia siliqua :: Carob 97 | 2362 Taylor St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 19 | Width 6ft | 6008379.56749 | 2121591.49972 | 37.8059584895516 | -122.415278208017 | (37.8059584895516, -122.415278208017) | |||
188551 | 188551 | 125981 | Undocumented 2 | Ceratonia siliqua :: Carob 97 | 2362 Taylor St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 19 | Width 6ft | 6008384.91577 | 2121552.17509 | 37.8058508146246 | -122.415256913874 | (37.8058508146246, -122.415256913874) | |||
39568 | 39568 | 125980 | Undocumented 2 | Ceratonia siliqua :: Carob 97 | 2362 Taylor St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 4ft | 6008387.31056 | 2121533.89692 | 37.8058007619722 | -122.415247331605 | (37.8058007619722, -122.415247331605) | |||
169791 | 169791 | 125979 | Undocumented 2 | Ceratonia siliqua :: Carob 97 | 2360 Taylor St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | Width 4ft | 6008389.02756 | 2121512.5692 | 37.80574229793179 | -122.41523987893999 | (37.8057422979318, -122.41523987894) | |||
174929 | 174929 | 125978 | Undocumented 2 | Ceratonia siliqua :: Carob 97 | 2360 Taylor St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 4ft | 6008392.85025 | 2121496.40648 | 37.8056981340166 | -122.415225505068 | (37.8056981340166, -122.415225505068) | |||
175928 | 175928 | 125977 | Undocumented 2 | Ceratonia siliqua :: Carob 97 | 2360 Taylor St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 13 | Width 4ft | 6008401.628880001 | 2121444.29683 | 37.8055555474172 | -122.415191434251 | (37.8055555474172, -122.415191434251) | |||
88377 | 88377 | 21777 | Permitted Site 1 | Ceratonia siliqua :: Carob 97 | 2500X Taylor St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/15/1992 12:00:00 AM | 3 | 3x3 | 6008409.452819999 | 2121407.87429 | 37.8054559800011 | -122.415161778523 | (37.8054559800011, -122.415161778523) |
JSON shape: default, array, newline-delimited
CREATE TABLE "Street_Tree_List" ( "TreeID" INTEGER, "qLegalStatus" INTEGER, "qSpecies" INTEGER, "qAddress" TEXT, "SiteOrder" INTEGER, "qSiteInfo" INTEGER, "PlantType" INTEGER, "qCaretaker" INTEGER, "qCareAssistant" INTEGER, "PlantDate" TEXT, "DBH" INTEGER, "PlotSize" TEXT, "PermitNotes" TEXT, "XCoord" REAL, "YCoord" REAL, "Latitude" REAL, "Longitude" REAL, "Location" TEXT , FOREIGN KEY ("PlantType") REFERENCES [PlantType](id), FOREIGN KEY ("qCaretaker") REFERENCES [qCaretaker](id), FOREIGN KEY ("qSpecies") REFERENCES [qSpecies](id), FOREIGN KEY ("qSiteInfo") REFERENCES [qSiteInfo](id), FOREIGN KEY ("qCareAssistant") REFERENCES [qCareAssistant](id), FOREIGN KEY ("qLegalStatus") REFERENCES [qLegalStatus](id)); CREATE INDEX ["Street_Tree_List_PlantType"] ON [Street_Tree_List]("PlantType"); CREATE INDEX ["Street_Tree_List_qCaretaker"] ON [Street_Tree_List]("qCaretaker"); CREATE INDEX ["Street_Tree_List_qSpecies"] ON [Street_Tree_List]("qSpecies"); CREATE INDEX ["Street_Tree_List_qSiteInfo"] ON [Street_Tree_List]("qSiteInfo"); CREATE INDEX ["Street_Tree_List_qCareAssistant"] ON [Street_Tree_List]("qCareAssistant"); CREATE INDEX ["Street_Tree_List_qLegalStatus"] ON [Street_Tree_List]("qLegalStatus");