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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 42249 | 42249 | 105036 | Permitted Site 1 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 1550 04th St | 11 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | 6x6 | Permit Number 771181 | 6015089.32821 | 2107914.09587 | 37.7687782840212 | -122.39110121906201 | (37.7687782840212, -122.391101219062) | ||
| 29379 | 29379 | 105035 | Permitted Site 1 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 1550 04th St | 10 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | 6x6 | 6015087.4436800005 | 2107939.01173 | 37.768846592924 | -122.391109479333 | (37.768846592924, -122.391109479333) | |||
| 177608 | 177608 | 191346 | Undocumented 2 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 1550 04th St | 9 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 5ft | 6015085.76507 | 2107965.02098 | 37.768917915461294 | -122.391117103785 | (37.7689179154613, -122.391117103785) | |||
| 51298 | 51298 | 200113 | Undocumented 2 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 1566 Yosemite Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 0ft | 6014774.445 | 2092572.7944 | 37.7266368132033 | -122.391117932915 | (37.7266368132033, -122.391117932915) | |||
| 136667 | 136667 | 191345 | Undocumented 2 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 1550 04th St | 8 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 5ft | 6015084.02733 | 2107988.1043 | 37.7689812007549 | -122.391124728238 | (37.7689812007549, -122.391124728238) | |||
| 53758 | 53758 | 191344 | Undocumented 2 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 1550 04th St | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 5ft | 6015083.2703599995 | 2108014.27768 | 37.769053025099105 | -122.39112917626998 | (37.7690530250991, -122.39112917627) | |||
| 66308 | 66308 | 105031 | Permitted Site 1 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 1550 04th St | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | 6x6 | 6015081.19497 | 2108038.83155 | 37.7691203294602 | -122.391138071471 | (37.7691203294602, -122.391138071471) | |||
| 137702 | 137702 | 105030 | Permitted Site 1 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 1550 04th St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | 6x6 | 6015079.85403 | 2108063.37025 | 37.769187632923604 | -122.391144425184 | (37.7691876329236, -122.391144425184) | |||
| 59549 | 59549 | 105029 | Permitted Site 1 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 1550 04th St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | 6x6 | 6015077.74883 | 2108086.46133 | 37.769250919128 | -122.391153321267 | (37.769250919128, -122.391153321267) | |||
| 170367 | 170367 | 105028 | Permitted Site 1 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 1550 04th St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | 6x6 | 6015077.92484 | 2108113.3475599997 | 37.7693247525719 | -122.391154592016 | (37.7693247525719, -122.391154592016) | |||
| 70706 | 70706 | 105027 | Permitted Site 1 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 1550 04th St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | 6x6 | 6015075.4785400005 | 2108137.72551 | 37.7693915533068 | -122.391164757946 | (37.7693915533068, -122.391164757946) | |||
| 49942 | 49942 | 105026 | Permitted Site 1 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 1550 04th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | 6x6 | 6015072.88546 | 2108163.93601 | 37.7694633776739 | -122.39117555971599 | (37.7694633776739, -122.391175559716) | |||
| 173859 | 173859 | 191343 | Undocumented 2 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 1450 04th St | 8 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 5ft | 6015066.17772 | 2108313.11356 | 37.769872614151396 | -122.39120919074499 | (37.7698726141514, -122.391209190745) | |||
| 53688 | 53688 | 191342 | Undocumented 2 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 1450 04th St | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 5ft | 6015064.99922 | 2108338.84414 | 37.769943199256794 | -122.391215066031 | (37.7699431992568, -122.391215066031) | |||
| 70045 | 70045 | 191341 | Undocumented 2 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 1450 04th St | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 5ft | 6015063.13507 | 2108364.25056 | 37.770012856238395 | -122.391223290338 | (37.7700128562384, -122.391223290338) | |||
| 53819 | 53819 | 191340 | Undocumented 2 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 1450 04th St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 5ft | 6015061.94317 | 2108389.30473 | 37.7700815833249 | -122.39122916471001 | (37.7700815833249, -122.39122916471) | |||
| 186532 | 186532 | 191339 | Undocumented 2 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 1450 04th St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 5ft | 6015062.12286 | 2108415.00786 | 37.7701521684295 | -122.391230340108 | (37.7701521684295, -122.391230340108) | |||
| 174040 | 174040 | 191338 | Undocumented 2 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 1450 04th St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 5ft | 6015059.91247 | 2108440.08294 | 37.770220896405704 | -122.39123973893899 | (37.7702208964057, -122.391239738939) | |||
| 180428 | 180428 | 191337 | Undocumented 2 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 1450 04th St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 5ft | 6015057.64715 | 2108462.45276 | 37.7702821932842 | -122.39124913866002 | (37.7702821932842, -122.39124913866) | |||
| 35192 | 35192 | 191336 | Undocumented 2 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 1450 04th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 5ft | 6015056.82202 | 2108488.85287 | 37.7703546363753 | -122.391253838509 | (37.7703546363753, -122.391253838509) | |||
| 155770 | 155770 | 191267 | Undocumented 2 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 538 Delancey St | 3 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 7 | 6015157.461180001 | 2113744.4936599997 | 37.7847910341296 | -122.391273164948 | (37.7847910341296, -122.391273164948) | ||||
| 66851 | 66851 | 191268 | Undocumented 2 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 538 Delancey St | 5 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 4 | 6015150.51675 | 2113731.33336 | 37.7847545135408 | -122.391296270324 | (37.7847545135408, -122.391296270324) | ||||
| 22918 | 22918 | 191269 | Undocumented 2 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 538 Delancey St | 6 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 8 | 6015147.69888 | 2113724.07494 | 37.7847344271845 | -122.391305511737 | (37.7847344271845, -122.391305511737) | ||||
| 131178 | 131178 | 66298 | Permitted Site 1 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 2920 Hawes St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/27/1990 12:00:00 AM | 6 | 3x3 | Permit Number 29409 | 6014606.2975 | 2089345.5816 | 37.7177661944335 | -122.391473700889 | (37.7177661944335, -122.391473700889) | |
| 154442 | 154442 | 191335 | Undocumented 2 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 1108 04th St | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 5ft | 6014898.40719 | 2110003.75259 | 37.774505422222 | -122.391907747266 | (37.774505422222, -122.391907747266) | |||
| 155061 | 155061 | 191334 | Undocumented 2 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 1108 04th St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 5ft | 6014881.31548 | 2110022.28226 | 37.7745553516884 | -122.391968167293 | (37.7745553516884, -122.391968167293) | |||
| 28729 | 28729 | 191333 | Undocumented 2 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 1108 04th St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 5ft | 6014865.84277 | 2110042.3598599997 | 37.7746096212801 | -122.392023095184 | (37.7746096212801, -122.392023095184) | |||
| 73709 | 73709 | 191332 | Undocumented 2 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 1108 04th St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 5ft | 6014847.27565 | 2110066.45331 | 37.774674745668996 | -122.392089008326 | (37.774674745669, -122.392089008326) | |||
| 179838 | 179838 | 191331 | Undocumented 2 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 1108 04th St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 5ft | 6014830.54088 | 2110082.99883 | 37.77471924682621 | -122.392148055082 | (37.7747192468262, -122.392148055082) | |||
| 60304 | 60304 | 191330 | Undocumented 2 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 1108 04th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 5ft | 6014815.79386 | 2110104.2477700002 | 37.7747767728644 | -122.392200554832 | (37.7747767728644, -122.392200554832) | |||
| 156796 | 156796 | 191266 | Undocumented 2 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 1721 Revere Ave | 1 | : 4 | Tree 1 | Private 1 | 25 | Width 9ft | 6014437.69224 | 2094855.17275 | 37.7328850694924 | -122.39244165855499 | (37.7328850694924, -122.392441658555) | |||
| 61026 | 61026 | 191297 | Undocumented 2 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 740 04th St | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 2ft | 6014617.26494 | 2110308.92783 | 37.7753277532976 | -122.39290163570101 | (37.7753277532976, -122.392901635701) | |||
| 39185 | 39185 | 191296 | Undocumented 2 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 740 04th St | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 2ft | 6014597.305819999 | 2110326.98215 | 37.7753762177666 | -122.392971942918 | (37.7753762177666, -122.392971942918) | |||
| 44145 | 44145 | 191295 | Undocumented 2 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 740 04th St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 2ft | 6014582.55786 | 2110345.63689 | 37.7754266202868 | -122.393024265473 | (37.7754266202868, -122.393024265473) | |||
| 167148 | 167148 | 191294 | Undocumented 2 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 740 04th St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 2ft | 6014564.69623 | 2110362.23682 | 37.775471207769606 | -122.393087215303 | (37.7754712077696, -122.393087215303) | |||
| 149339 | 149339 | 191293 | Undocumented 2 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 740 04th St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 2ft | 6014546.37169 | 2110379.31646 | 37.775517086679 | -122.393151800112 | (37.775517086679, -122.393151800112) | |||
| 163250 | 163250 | 191292 | Undocumented 2 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 740 04th St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 2ft | 6014526.81372 | 2110393.83261 | 37.7755558582611 | -122.393220472347 | (37.7755558582611, -122.393220472347) | |||
| 44547 | 44547 | 191291 | Undocumented 2 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 740 04th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 2ft | 6014507.50601 | 2110409.04953 | 37.7755965678638 | -122.39328832798701 | (37.7755965678638, -122.393288327987) | |||
| 172373 | 172373 | 191279 | Undocumented 2 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 751 04th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 2ft | 6014488.651430001 | 2110553.2747 | 37.7759915303161 | -122.393363646226 | (37.7759915303161, -122.393363646226) | |||
| 173577 | 173577 | 191280 | Undocumented 2 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 751 04th St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 2ft | 6014475.48285 | 2110565.8320299997 | 37.776025278288294 | -122.393410079138 | (37.7760252782883, -122.393410079138) | |||
| 65427 | 65427 | 191281 | Undocumented 2 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 751 04th St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 2ft | 6014459.12873 | 2110582.79031 | 37.776070933269 | -122.39346783987301 | (37.776070933269, -122.393467839873) | |||
| 64760 | 64760 | 191282 | Undocumented 2 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 751 04th St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 2ft | 6014441.41184 | 2110601.16162 | 37.77612039236389 | -122.393530413818 | (37.7761203923639, -122.393530413818) | |||
| 134094 | 134094 | 191283 | Undocumented 2 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 751 04th St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 2ft | 6014423.24539 | 2110620.23478 | 37.7761717535676 | -122.39359459213999 | (37.7761717535676, -122.39359459214) | |||
| 74191 | 74191 | 191290 | Undocumented 2 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 720 04th St | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 2ft | 6014418.027919999 | 2110488.47672 | 37.7758096856109 | -122.393603417186 | (37.7758096856109, -122.393603417186) | |||
| 173431 | 173431 | 191284 | Undocumented 2 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 751 04th St | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 2ft | 6014408.26812 | 2110636.4725 | 37.7762155064684 | -122.39364753972201 | (37.7762155064684, -122.393647539722) | |||
| 179903 | 179903 | 191289 | Undocumented 2 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 720 04th St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 2ft | 6014403.282380001 | 2110504.70975 | 37.7758534385095 | -122.393655562567 | (37.7758534385095, -122.393655562567) | |||
| 166600 | 166600 | 191288 | Undocumented 2 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 720 04th St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 2ft | 6014381.59657 | 2110521.77598 | 37.7758990935001 | -122.39373177471 | (37.7758990935001, -122.39373177471) | |||
| 27568 | 27568 | 191287 | Undocumented 2 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 720 04th St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 2ft | 6014360.2734 | 2110545.30097 | 37.7759625028975 | -122.393807184665 | (37.7759625028975, -122.393807184665) | |||
| 177153 | 177153 | 191286 | Undocumented 2 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 720 04th St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 2ft | 6014348.90708 | 2110556.6159200002 | 37.7759929395558 | -122.39384729623801 | (37.7759929395558, -122.393847296238) | |||
| 67551 | 67551 | 191285 | Undocumented 2 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 720 04th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 2ft | 6014337.49405 | 2110565.62241 | 37.776017035092 | -122.39388740780001 | (37.776017035092, -122.3938874078) | |||
| 162297 | 162297 | 191270 | Undocumented 2 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 659 04th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 3ft | 6014244.47605 | 2110787.29844 | 37.7766205377503 | -122.39422470752899 | (37.7766205377503, -122.394224707529) | |||
| 37043 | 37043 | 191271 | Undocumented 2 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 659 04th St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 3ft | 6014227.23158 | 2110805.88928 | 37.776670625478395 | -122.394285663563 | (37.7766706254784, -122.394285663563) | |||
| 62414 | 62414 | 191272 | Undocumented 2 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 659 04th St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 3ft | 6014208.1321 | 2110827.64494 | 37.776729299941394 | -122.394353258399 | (37.7767292999414, -122.394353258399) | |||
| 168646 | 168646 | 191273 | Undocumented 2 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 659 04th St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 3ft | 6014193.41583 | 2110841.8415900003 | 37.7767674626879 | -122.394405160994 | (37.7767674626879, -122.394405160994) | |||
| 64764 | 64764 | 191274 | Undocumented 2 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 659 04th St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 3ft | 6014170.53603 | 2110866.45323 | 37.7768337688053 | -122.394486033405 | (37.7768337688053, -122.394486033405) | |||
| 178335 | 178335 | 191275 | Undocumented 2 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 659 04th St | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 3ft | 6014152.76855 | 2110885.05471 | 37.7768838565355 | -122.394548799799 | (37.7768838565355, -122.394548799799) | |||
| 71984 | 71984 | 191276 | Undocumented 2 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 659 04th St | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 3ft | 6014137.59227 | 2110902.38763 | 37.776930605110394 | -122.394602513603 | (37.7769306051104, -122.394602513603) | |||
| 72025 | 72025 | 191277 | Undocumented 2 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 659 04th St | 8 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 3ft | 6014120.49796 | 2110919.7593900003 | 37.7769773536703 | -122.394662865301 | (37.7769773536703, -122.394662865301) | |||
| 169237 | 169237 | 191278 | Undocumented 2 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 659 04th St | 9 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 3ft | 6014098.280590001 | 2110942.62046 | 37.777038889768896 | -122.39474132397801 | (37.7770388897689, -122.394741323978) | |||
| 34497 | 34497 | 191363 | Undocumented 2 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 955 Key Ave | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 13 | 6013550.52728 | 2089583.75311 | 37.7183615103672 | -122.395139727222 | (37.7183615103672, -122.395139727222) | ||||
| 62074 | 62074 | 94211 | Permitted Site 1 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 465 Missouri St | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/22/2010 12:00:00 AM | 3 | 3x3 | Permit Number 53589 | 6013546.79092 | 2104912.40006 | 37.760450569952205 | -122.39622637625799 | (37.7604505699522, -122.396226376258) | |
| 172150 | 172150 | 94214 | Permitted Site 1 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 465 Missouri St | 9 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/22/2010 12:00:00 AM | 3 | 3x3 | Permit Number 53589 | 6013545.016969999 | 2104957.62874 | 37.7605746593094 | -122.396235681545 | (37.7605746593094, -122.396235681545) | |
| 62932 | 62932 | 108753 | Undocumented 2 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 200x Hester Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | 3x3 | 6012766.4768 | 2087726.3545799998 | 37.713217830719294 | -122.397719670851 | (37.7132178307193, -122.397719670851) | |||
| 29524 | 29524 | 108754 | Undocumented 2 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 200x Hester Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | 3x3 | 6012760.63999 | 2087707.7823400002 | 37.7131665099896 | -122.397738543111 | (37.7131665099896, -122.397738543111) | |||
| 182528 | 182528 | 176929 | Undocumented 2 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 110 Hester Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 2ft | 6012755.76956 | 2087791.93581 | 37.7133973075252 | -122.397761276185 | (37.7133973075252, -122.397761276185) | |||
| 148773 | 148773 | 176956 | Undocumented 2 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 99 Lois Ln | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 2ft | 6012750.523080001 | 2087747.4076 | 37.713274749713605 | -122.39777628854799 | (37.7132747497136, -122.397776288548) | |||
| 169093 | 169093 | 176928 | Undocumented 2 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 110 Hester Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 2ft | 6012745.689669999 | 2087817.6299700001 | 37.713467297259996 | -122.397797917233 | (37.71346729726, -122.397797917233) | |||
| 43531 | 43531 | 191264 | Undocumented 2 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 801 Arkansas St | 30 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 19 | 6013055.03201 | 2103799.19748 | 37.7573665842245 | -122.39784906707399 | (37.7573665842245, -122.397849067074) | ||||
| 179315 | 179315 | 176955 | Undocumented 2 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 95 Lois Ln | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 2ft | 6012720.393999999 | 2087742.5814099999 | 37.7132598200564 | -122.397880087391 | (37.7132598200564, -122.397880087391) | |||
| 138206 | 138206 | 176957 | Undocumented 2 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 208 Hester Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 2ft | 6012704.399540001 | 2087660.6669400001 | 37.7130340083786 | -122.397929627449 | (37.7130340083786, -122.397929627449) | |||
| 169089 | 169089 | 176954 | Undocumented 2 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 95 Lois Ln | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 2ft | 6012699.50978 | 2087739.26695 | 37.713249556105104 | -122.397952038554 | (37.7132495561051, -122.397952038554) | |||
| 45505 | 45505 | 176953 | Undocumented 2 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 79 Lois Ln | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 2ft | 6012671.13481 | 2087736.7840599997 | 37.713241158228705 | -122.39804993876999 | (37.7132411582287, -122.39804993877) | |||
| 78926 | 78926 | 112621 | Undocumented 2 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 226x HESTER AVE | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6012667.0 | 2087636.0 | 37.712964194877294 | -122.398057164184 | (37.7129641948773, -122.398057164184) | ||||
| 177180 | 177180 | 176930 | Undocumented 2 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 78 Lois Ln | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 2ft | 6012665.081590001 | 2087756.9566900001 | 37.7132962111247 | -122.39807227523501 | (37.7132962111247, -122.398072275235) | |||
| 38656 | 38656 | 176952 | Undocumented 2 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 75 Lois Ln | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 2ft | 6012648.82319 | 2087733.77895 | 37.713231664082706 | -122.39812684519698 | (37.7132316640827, -122.398126845197) | |||
| 148062 | 148062 | 176958 | Undocumented 2 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 214 Hester Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 2ft | 6012631.12356 | 2087648.5603099999 | 37.7129966847253 | -122.39818204648701 | (37.7129966847253, -122.398182046487) | |||
| 69520 | 69520 | 176931 | Undocumented 2 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 68 Lois Ln | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 2ft | 6012597.15839 | 2087748.03583 | 37.713267932833794 | -122.398306417307 | (37.7132679328338, -122.398306417307) | |||
| 35610 | 35610 | 176951 | Undocumented 2 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 63 Lois Ln | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 2ft | 6012562.34064 | 2087723.35892 | 37.7131982353775 | -122.398425029786 | (37.7131982353775, -122.398425029786) | |||
| 186617 | 186617 | 176959 | Undocumented 2 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 228 Hester Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 2ft | 6012551.8348 | 2087659.68415 | 37.7130228118314 | -122.398456876593 | (37.7130228118314, -122.398456876593) | |||
| 64660 | 64660 | 176932 | Undocumented 2 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 56 Lois Ln | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 2ft | 6012552.9526 | 2087748.4178 | 37.7132665190974 | -122.39845923552299 | (37.7132665190974, -122.398459235523) | |||
| 44632 | 44632 | 176950 | Undocumented 2 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 59 Lois Ln | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 2ft | 6012544.33708 | 2087727.46225 | 37.7132084993531 | -122.398487544387 | (37.7132084993531, -122.398487544387) | |||
| 150169 | 150169 | 176933 | Undocumented 2 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 56 Lois Ln | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 2ft | 6012542.43425 | 2087752.49307 | 37.7132771230101 | -122.398495876584 | (37.7132771230101, -122.398495876584) | |||
| 94418 | 94418 | 112623 | Undocumented 2 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 228 HESTER AVE | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x2 | 6012539.0 | 2087662.0 | 37.7130284556779 | -122.398501400627 | (37.7130284556779, -122.398501400627) | ||||
| 177487 | 177487 | 176949 | Undocumented 2 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 59 Lois Ln | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 2ft | 6012531.85348 | 2087734.51235 | 37.7132271620641 | -122.39853118666201 | (37.7132271620641, -122.398531186662) | |||
| 171606 | 171606 | 176934 | Undocumented 2 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 52 Lois Ln | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 2ft | 6012523.28008 | 2087764.2105 | 37.7133082296521 | -122.398562902163 | (37.7133082296521, -122.398562902163) | |||
| 52561 | 52561 | 114222 | Undocumented 2 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 55 Lois Ln | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | 2x2 | 6012512.59554 | 2087744.0784200002 | 37.713252355697605 | -122.398598420002 | (37.7132523556976, -122.398598420002) | |||
| 169932 | 169932 | 176948 | Undocumented 2 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 43 Lois Ln | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 2ft | 6012470.82697 | 2087771.0926700002 | 37.7133242043273 | -122.39874468213101 | (37.7133242043273, -122.398744682131) | |||
| 181722 | 181722 | 176935 | Undocumented 2 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 38 Lois Ln | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 2ft | 6012462.52056 | 2087802.51935 | 37.7134100329326 | -122.398775596322 | (37.7134100329326, -122.398775596322) | |||
| 26316 | 26316 | 176960 | Undocumented 2 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 242 Hester Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 2ft | 6012452.5611 | 2087695.0016599998 | 37.7131142557927 | -122.39880247885701 | (37.7131142557927, -122.398802478857) | |||
| 183903 | 183903 | 176947 | Undocumented 2 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 39 Lois Ln | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 2ft | 6012433.06951 | 2087793.9478900002 | 37.713384856409 | -122.398876788934 | (37.713384856409, -122.398876788934) | |||
| 133916 | 133916 | 176946 | Undocumented 2 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 33 Lois Ln | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 2ft | 6012391.32203 | 2087821.98143 | 37.7134595046344 | -122.39902305019699 | (37.7134595046344, -122.399023050197) | |||
| 132161 | 132161 | 176945 | Undocumented 2 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 31 Lois Ln | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 2ft | 6012378.545530001 | 2087831.41605 | 37.7134846982415 | -122.399067872395 | (37.7134846982415, -122.399067872395) | |||
| 182745 | 182745 | 114221 | Undocumented 2 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 28 Lois Ln | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | 3x3 | 6012377.24762 | 2087856.00195 | 37.7135521339029 | -122.39907408311599 | (37.7135521339029, -122.399074083116) | |||
| 131733 | 131733 | 191263 | Undocumented 2 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 728 Wisconsin St | 2 | : 4 | Tree 1 | Private 1 | 13 | Width 3ft | 6012693.0382199995 | 2104091.70249 | 37.7581495726586 | -122.399121524154 | (37.7581495726586, -122.399121524154) | |||
| 14017 | 14017 | 104025 | Undocumented 2 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 716 Wisconsin St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 16 | 3x3 | 6012687.87968 | 2104149.7182 | 37.7583085835989 | -122.399143437016 | (37.7583085835989, -122.399143437016) | |||
| 161305 | 161305 | 114220 | Undocumented 2 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 31 Lois Ln | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | 3x3 | 6012353.592019999 | 2087846.1951099997 | 37.713523887993105 | -122.39915515788799 | (37.7135238879931, -122.399155157888) | |||
| 46965 | 46965 | 176936 | Undocumented 2 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 20 Lois Ln | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 2ft | 6012351.49393 | 2087873.7751200001 | 37.713599500286 | -122.399164344459 | (37.713599500286, -122.399164344459) | |||
| 149495 | 149495 | 114219 | Undocumented 2 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 31 Lois Ln | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | 3x3 | 6012347.17965 | 2087849.72367 | 37.713533219358396 | -122.399177569 | (37.7135332193584, -122.399177569) | |||
| 56561 | 56561 | 191262 | Undocumented 2 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 690 Wisconsin St | 5 | : 4 | Tree 1 | Private 1 | 15 | Width 3ft | 6012676.19431 | 2104276.36771 | 37.7586556841436 | -122.399192740559 | (37.7586556841436, -122.399192740559) | |||
| 177184 | 177184 | 191261 | Undocumented 2 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 690 Wisconsin St | 3 | : 4 | Tree 1 | Private 1 | 18 | Width 3ft | 6012675.54577 | 2104288.99957 | 37.7586903323146 | -122.399195870217 | (37.7586903323146, -122.399195870217) |
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");