Data source: data.sfgov.org
This data as json, CSV (advanced)
Suggested facets: qLegalStatus, qAddress, qCaretaker, PlantDate, DBH
| Link | rowid ▼ | TreeID | qLegalStatus | qSpecies | qAddress | SiteOrder | qSiteInfo | PlantType | qCaretaker | qCareAssistant | PlantDate | DBH | PlotSize | PermitNotes | XCoord | YCoord | Latitude | Longitude | Location |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 1076 | 1076 | 3599 | Permitted Site 1 | Quercus ilex :: Holly Oak 78 | 100X Cargo Way | 35 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Port 9 | 05/01/2017 03:11:00 PM | 3 | 3X3 | 6018236.38581 | 2098046.3275599997 | 37.7418575659771 | -122.37953006857799 | (37.7418575659771, -122.379530068578) | ||
| 1079 | 1079 | 3621 | Private 5 | Quercus ilex :: Holly Oak 78 | 100X Cargo Way | 57 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Port 9 | 05/01/2017 03:22:00 PM | 3 | 3X3 | 6017849.66978 | 2098333.64293 | 37.7426251400454 | -122.380887189608 | (37.7426251400454, -122.380887189608) | ||
| 4934 | 4934 | 3524 | DPW Maintained 3 | Quercus ilex :: Holly Oak 78 | 201X Cargo Way | 34 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 04/10/2017 11:27:00 AM | 3 | 3X3 | 6018232.23392 | 2097945.31305 | 37.7415799713464 | -122.37953740884399 | (37.7415799713464, -122.379537408844) | ||
| 4936 | 4936 | 3492 | DPW Maintained 3 | Quercus ilex :: Holly Oak 78 | 201X Cargo Way | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 05/03/2017 10:28:00 AM | 3 | 3X3 | 6017600.3443599995 | 2098412.1206099996 | 37.7428268597689 | -122.38175475027599 | (37.7428268597689, -122.381754750276) | ||
| 4945 | 4945 | 3600 | Private 5 | Quercus ilex :: Holly Oak 78 | 100X Cargo Way | 36 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Port 9 | 05/01/2017 03:14:00 PM | 3 | 3X3 | 6018222.967130001 | 2098056.59418 | 37.7418850159701 | -122.379577179554 | (37.7418850159701, -122.379577179554) | ||
| 4948 | 4948 | 3641 | Permitted Site 1 | Quercus ilex :: Holly Oak 78 | 100X Cargo Way | 77 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Port 9 | 05/01/2017 03:31:00 PM | 3 | 3X3 | 6017517.08856 | 2098593.13553 | 37.7433192925522 | -122.38205521738999 | (37.7433192925522, -122.38205521739) | ||
| 4950 | 4950 | 3646 | Private 5 | Quercus ilex :: Holly Oak 78 | 100X Cargo Way | 82 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Port 9 | 04/10/2017 10:16:00 AM | 3 | 3X3 | 6017441.11571 | 2098662.50366 | 37.7435055673357 | -122.38232273959999 | (37.7435055673357, -122.3823227396) | ||
| 4952 | 4952 | 3661 | Permitted Site 1 | Quercus ilex :: Holly Oak 78 | 100X Cargo Way | 97 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Port 9 | 05/02/2017 12:21:00 PM | 3 | 3X3 | 6017220.32274 | 2098859.87245 | 37.7440353039781 | -122.38309992831199 | (37.7440353039781, -122.383099928312) | ||
| 4962 | 4962 | 3595 | Permitted Site 1 | Quercus ilex :: Holly Oak 78 | 100X Cargo Way | 31 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Port 9 | 03/18/2017 03:05:00 PM | 3 | 3X3 | 6018306.03367 | 2097993.65704 | 37.741716784307606 | -122.379285588775 | (37.7417167843076, -122.379285588775) | ||
| 4973 | 4973 | 3631 | Private 5 | Quercus ilex :: Holly Oak 78 | 100X Cargo Way | 67 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Port 9 | 05/01/2017 03:27:00 PM | 3 | 3X3 | 6017682.09522 | 2098458.88711 | 37.7429597849556 | -122.381475327351 | (37.7429597849556, -122.381475327351) | ||
| 4994 | 4994 | 3624 | Private 5 | Quercus ilex :: Holly Oak 78 | 100X Cargo Way | 60 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Port 9 | 05/01/2017 03:25:00 PM | 3 | 3X3 | 6017797.96297 | 2098371.7943700003 | 37.742727042232396 | -122.38106863050601 | (37.7427270422324, -122.381068630506) | ||
| 5002 | 5002 | 3650 | Permitted Site 1 | Quercus ilex :: Holly Oak 78 | 100X Cargo Way | 86 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Port 9 | 04/10/2017 10:18:00 AM | 3 | 3X3 | 6017379.34335 | 2098718.96834 | 37.743657195713396 | -122.382540263146 | (37.7436571957134, -122.382540263146) | ||
| 5003 | 5003 | 3497 | DPW Maintained 3 | Quercus ilex :: Holly Oak 78 | 201X Cargo Way | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 04/10/2017 11:36:00 AM | 3 | 3X3 | 6017681.58024 | 2098352.39138 | 37.7426673407245 | -122.38146970386002 | (37.7426673407245, -122.38146970386) | ||
| 5005 | 5005 | 3535 | DPW Maintained 3 | Quercus ilex :: Holly Oak 78 | 201X Cargo Way | 45 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 05/03/2017 08:14:00 AM | 3 | 3X3 | 6018417.72714 | 2097807.1699900003 | 37.7412108868837 | -122.37888643815799 | (37.7412108868837, -122.378886438158) | ||
| 5013 | 5013 | 3501 | DPW Maintained 3 | Quercus ilex :: Holly Oak 78 | 201X Cargo Way | 11 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 05/03/2017 10:19:00 AM | 3 | 3X3 | 6017757.788930001 | 2098294.27861 | 37.742511981949605 | -122.381202153752 | (37.7425119819496, -122.381202153752) | ||
| 5015 | 5015 | 3533 | DPW Maintained 3 | Quercus ilex :: Holly Oak 78 | 201X Cargo Way | 43 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 04/10/2017 11:14:00 AM | 3 | 3X3 | 6018385.2534300005 | 2097830.3322900003 | 37.7412726954727 | -122.379000330107 | (37.7412726954727, -122.379000330107) | ||
| 5023 | 5023 | 3601 | Private 5 | Quercus ilex :: Holly Oak 78 | 100X Cargo Way | 37 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Port 9 | 04/10/2017 10:11:00 AM | 3 | 3X3 | 6018206.00756 | 2098069.0742900004 | 37.7419183484432 | -122.379636687689 | (37.7419183484432, -122.379636687689) | ||
| 5035 | 5035 | 3620 | Permitted Site 1 | Quercus ilex :: Holly Oak 78 | 100X Cargo Way | 56 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Port 9 | 05/01/2017 03:20:00 PM | 3 | 3X3 | 6017867.03936 | 2098322.52996 | 37.7425955847281 | -122.380826357655 | (37.7425955847281, -122.380826357655) | ||
| 5052 | 5052 | 3586 | Permitted Site 1 | Quercus ilex :: Holly Oak 78 | 100X Cargo Way | 22 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Port 9 | 04/10/2017 10:01:00 AM | 3 | 3X3 | 6018456.23147 | 2097881.24253 | 37.74141639814229 | -122.378758444849 | (37.7414163981423, -122.378758444849) | ||
| 5063 | 5063 | 3598 | Private 5 | Quercus ilex :: Holly Oak 78 | 100X Cargo Way | 34 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Port 9 | 05/01/2017 03:10:00 PM | 3 | 3X3 | 6018255.028469999 | 2098031.9569200003 | 37.7418191352571 | -122.37946460960501 | (37.7418191352571, -122.379464609605) | ||
| 5067 | 5067 | 3644 | Permitted Site 1 | Quercus ilex :: Holly Oak 78 | 100X Cargo Way | 80 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Port 9 | 04/10/2017 10:15:00 AM | 3 | 3X3 | 6017471.8409400005 | 2098633.68097 | 37.7434281231236 | -122.382214493629 | (37.7434281231236, -122.382214493629) | ||
| 5070 | 5070 | 3618 | Private 5 | Quercus ilex :: Holly Oak 78 | 100X Cargo Way | 54 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Port 9 | 12 | 3X3 | 6017899.85524 | 2098296.735 | 37.7425265680461 | -122.380711096061 | (37.7425265680461, -122.380711096061) | |||
| 5077 | 5077 | 3660 | Permitted Site 1 | Quercus ilex :: Holly Oak 78 | 100X Cargo Way | 96 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Port 9 | 3 | 3X3 | 6017231.85716 | 2098842.1766 | 37.7439873521291 | -122.383058813116 | (37.7439873521291, -122.383058813116) | |||
| 13784 | 13784 | 3536 | DPW Maintained 3 | Quercus ilex :: Holly Oak 78 | 201X Cargo Way | 46 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 03/13/1990 12:00:00 AM | 6 | 3X3 | 6018434.89697 | 2097793.8014700003 | 37.741175126223204 | -122.378826142235 | (37.7411751262232, -122.378826142235) | ||
| 13788 | 13788 | 3654 | Permitted Site 1 | Quercus ilex :: Holly Oak 78 | 100X Cargo Way | 90 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Port 9 | 6 | 3X3 | 6017326.20806 | 2098774.96233 | 37.743808008441704 | -122.38272788957899 | (37.7438080084417, -122.382727889579) | |||
| 13807 | 13807 | 3515 | DPW Maintained 3 | Quercus ilex :: Holly Oak 78 | 201X Cargo Way | 25 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 04/30/1990 12:00:00 AM | 12 | 3X3 | 6018092.0886699995 | 2098050.06678 | 37.741859873634205 | -122.380029266058 | (37.7418598736342, -122.380029266058) | ||
| 13849 | 13849 | 3503 | DPW Maintained 3 | Quercus ilex :: Holly Oak 78 | 201X Cargo Way | 13 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 3 | 3X3 | 6017795.07465 | 2098266.33581 | 37.742437314826496 | -122.38107128711201 | (37.7424373148265, -122.381071287112) | |||
| 13920 | 13920 | 3540 | DPW Maintained 3 | Quercus ilex :: Holly Oak 78 | 201X Cargo Way | 50 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 6 | 3X3 | 6018504.91252 | 2097742.5518 | 37.7410382647176 | -122.37858049328999 | (37.7410382647176, -122.37858049329) | |||
| 13941 | 13941 | 3603 | Permitted Site 1 | Quercus ilex :: Holly Oak 78 | 100X Cargo Way | 39 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Port 9 | 12 | 3X3 | 6018171.24251 | 2098094.76588 | 37.741986974834106 | -122.379758679838 | (37.7419869748341, -122.379758679838) | |||
| 14056 | 14056 | 3640 | Permitted Site 1 | Quercus ilex :: Holly Oak 78 | 100X Cargo Way | 76 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Port 9 | 12 | 3X3 | 6017536.43295 | 2098576.56598 | 37.7432748642351 | -122.381987176477 | (37.7432748642351, -122.381987176477) | |||
| 14225 | 14225 | 3498 | DPW Maintained 3 | Quercus ilex :: Holly Oak 78 | 201X Cargo Way | 8 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3X3 | 6017700.75455 | 2098337.80167 | 37.7426283389164 | -122.381402389631 | (37.7426283389164, -122.381402389631) | |||
| 14307 | 14307 | 3530 | DPW Maintained 3 | Quercus ilex :: Holly Oak 78 | 201X Cargo Way | 40 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 03/13/1990 12:00:00 AM | 6 | 3X3 | 6018336.58816 | 2097867.32601 | 37.7413715894385 | -122.379171168028 | (37.7413715894385, -122.379171168028) | ||
| 14413 | 14413 | 3500 | DPW Maintained 3 | Quercus ilex :: Holly Oak 78 | 201X Cargo Way | 10 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3X3 | 6017738.77776 | 2098309.39264 | 37.7425524325559 | -122.381268940124 | (37.7425524325559, -122.381268940124) | |||
| 14781 | 14781 | 3543 | DPW Maintained 3 | Quercus ilex :: Holly Oak 78 | 201X Cargo Way | 53 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 03/01/2000 12:00:00 AM | 3 | 3X3 | 6018555.97345 | 2097704.22378 | 37.74093583821671 | -122.378401280909 | (37.7409358382167, -122.378401280909) | ||
| 14783 | 14783 | 3633 | Permitted Site 1 | Quercus ilex :: Holly Oak 78 | 100X Cargo Way | 69 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Port 9 | 6 | 3X3 | 6017649.0599 | 2098484.04513 | 37.743027039860394 | -122.381591304811 | (37.7430270398604, -122.381591304811) | |||
| 14987 | 14987 | 3529 | DPW Maintained 3 | Quercus ilex :: Holly Oak 78 | 201X Cargo Way | 39 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 03/07/2006 12:00:00 AM | 3 | 3X3 | 6018316.85209 | 2097881.54987 | 37.7414095570002 | -122.379240396934 | (37.7414095570002, -122.379240396934) | ||
| 15070 | 15070 | 3495 | DPW Maintained 3 | Quercus ilex :: Holly Oak 78 | 201X Cargo Way | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3X3 | 6017646.36043 | 2098378.21595 | 37.742736305236605 | -122.381593280624 | (37.7427363052366, -122.381593280624) | |||
| 15214 | 15214 | 3606 | Permitted Site 1 | Quercus ilex :: Holly Oak 78 | 100X Cargo Way | 42 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Port 9 | 12 | 3X3 | 6018122.20462 | 2098131.02661 | 37.742083834489605 | -122.379930757907 | (37.7420838344896, -122.379930757907) | |||
| 15250 | 15250 | 3496 | DPW Maintained 3 | Quercus ilex :: Holly Oak 78 | 201X Cargo Way | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3X3 | 6017663.23695 | 2098365.77973 | 37.74270308968379 | -122.381534061174 | (37.7427030896838, -122.381534061174) | |||
| 15411 | 15411 | 3504 | DPW Maintained 3 | Quercus ilex :: Holly Oak 78 | 201X Cargo Way | 14 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 6 | 3X3 | 6017814.43885 | 2098252.58182 | 37.7424006179895 | -122.3810033748 | (37.7424006179895, -122.3810033748) | |||
| 15487 | 15487 | 3499 | DPW Maintained 3 | Quercus ilex :: Holly Oak 78 | 201X Cargo Way | 9 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 6 | 3X3 | 6017721.1126 | 2098322.7096700002 | 37.742588023232 | -122.381330947484 | (37.742588023232, -122.381330947484) | |||
| 15506 | 15506 | 3509 | DPW Maintained 3 | Quercus ilex :: Holly Oak 78 | 201X Cargo Way | 19 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 03/07/2006 12:00:00 AM | 3 | 3X3 | 6017998.366640001 | 2098120.43609 | 37.742047922763795 | -122.380358219176 | (37.7420479227638, -122.380358219176) | ||
| 15552 | 15552 | 3616 | Permitted Site 1 | Quercus ilex :: Holly Oak 78 | 100X Cargo Way | 52 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Port 9 | 12 | 3X3 | 6017954.336080001 | 2098256.07975 | 37.7424179434233 | -122.38051989028901 | (37.7424179434233, -122.380519890289) | |||
| 15603 | 15603 | 3517 | DPW Maintained 3 | Quercus ilex :: Holly Oak 78 | 201X Cargo Way | 27 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 03/07/2006 12:00:00 AM | 3 | 3X3 | 6018124.75716 | 2098026.19045 | 37.741796116207105 | -122.37991464925899 | (37.7417961162071, -122.379914649259) | ||
| 15955 | 15955 | 3494 | DPW Maintained 3 | Quercus ilex :: Holly Oak 78 | 201X Cargo Way | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3X3 | 6017631.184309999 | 2098389.6910900003 | 37.7427669757157 | -122.38164655374099 | (37.7427669757157, -122.381646553741) | |||
| 16197 | 16197 | 3604 | Permitted Site 1 | Quercus ilex :: Holly Oak 78 | 100X Cargo Way | 40 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Port 9 | 6 | 3X3 | 6018155.728019999 | 2098107.78819 | 37.742021875700296 | -122.37981322911999 | (37.7420218757003, -122.37981322912) | |||
| 16339 | 16339 | 3548 | DPW Maintained 3 | Quercus ilex :: Holly Oak 78 | 201X Cargo Way | 58 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3X3 | 6018674.8366 | 2097616.25665 | 37.7407008489755 | -122.37798418701999 | (37.7407008489755, -122.37798418702) | |||
| 16830 | 16830 | 3619 | Permitted Site 1 | Quercus ilex :: Holly Oak 78 | 100X Cargo Way | 55 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Port 9 | 6 | 3X3 | 6017883.8496199995 | 2098309.7670299998 | 37.742561468052294 | -122.380767345063 | (37.7425614680523, -122.380767345063) | |||
| 22311 | 22311 | 3643 | Private 5 | Quercus ilex :: Holly Oak 78 | 100X Cargo Way | 79 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Port 9 | 6 | 3X3 | 6017487.6627 | 2098619.8542 | 37.7433910314633 | -122.382158823763 | (37.7433910314633, -122.382158823763) | |||
| 22315 | 22315 | 3636 | Private 5 | Quercus ilex :: Holly Oak 78 | 100X Cargo Way | 72 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Port 9 | 12 | 3X3 | 6017599.14752 | 2098522.45762 | 37.7431297568333 | -122.38176656108601 | (37.7431297568333, -122.381766561086) | |||
| 22317 | 22317 | 3653 | Permitted Site 1 | Quercus ilex :: Holly Oak 78 | 100X Cargo Way | 89 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Port 9 | 6 | 3X3 | 6017331.733030001 | 2098760.60047 | 37.7437688789233 | -122.382707786159 | (37.7437688789233, -122.382707786159) | |||
| 22322 | 22322 | 3590 | Permitted Site 1 | Quercus ilex :: Holly Oak 78 | 100X Cargo Way | 26 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Port 9 | 03/01/2006 12:00:00 AM | 3 | 3X3 | 6018389.26392 | 2097931.71648 | 37.7415512973552 | -122.378993502451 | (37.7415512973552, -122.378993502451) | ||
| 22324 | 22324 | 3625 | Permitted Site 1 | Quercus ilex :: Holly Oak 78 | 100X Cargo Way | 61 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Port 9 | 6 | 3X3 | 6017781.374919999 | 2098384.59743 | 37.7427612812112 | -122.38112687781 | (37.7427612812112, -122.38112687781) | |||
| 22328 | 22328 | 3612 | Private 5 | Quercus ilex :: Holly Oak 78 | 100X Cargo Way | 48 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Port 9 | 6 | 3X3 | 6018020.628269999 | 2098207.76094 | 37.7422889275932 | -122.380287312129 | (37.7422889275932, -122.380287312129) | |||
| 22332 | 22332 | 3637 | Permitted Site 1 | Quercus ilex :: Holly Oak 78 | 100X Cargo Way | 73 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Port 9 | 6 | 3X3 | 6017581.37685 | 2098535.7297 | 37.7431652179942 | -122.381828930869 | (37.7431652179942, -122.381828930869) | |||
| 22335 | 22335 | 3628 | Private 5 | Quercus ilex :: Holly Oak 78 | 100X Cargo Way | 64 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Port 9 | 6 | 3X3 | 6017730.69941 | 2098422.13413 | 37.7428615520079 | -122.38130471064899 | (37.7428615520079, -122.381304710649) | |||
| 22337 | 22337 | 3609 | Private 5 | Quercus ilex :: Holly Oak 78 | 100X Cargo Way | 45 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Port 9 | 9 | 3X3 | 6018070.77279 | 2098169.47823 | 37.7421865775631 | -122.380111266222 | (37.7421865775631, -122.380111266222) | |||
| 22338 | 22338 | 3608 | Private 5 | Quercus ilex :: Holly Oak 78 | 100X Cargo Way | 44 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Port 9 | 03/07/2006 12:00:00 AM | 3 | 3X3 | 6018087.01832 | 2098157.15518 | 37.7421536371939 | -122.380054237523 | (37.7421536371939, -122.380054237523) | ||
| 22339 | 22339 | 3642 | Private 5 | Quercus ilex :: Holly Oak 78 | 100X Cargo Way | 78 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Port 9 | 6 | 3X3 | 6017503.4842 | 2098606.02713 | 37.7433539389383 | -122.382103154832 | (37.7433539389383, -122.382103154832) | |||
| 22340 | 22340 | 3632 | Private 5 | Quercus ilex :: Holly Oak 78 | 100X Cargo Way | 68 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Port 9 | 6 | 3X3 | 6017663.5913 | 2098472.7680200003 | 37.7429968775117 | -122.38154027458799 | (37.7429968775117, -122.381540274588) | |||
| 22351 | 22351 | 3656 | Permitted Site 1 | Quercus ilex :: Holly Oak 78 | 100X Cargo Way | 92 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Port 9 | 03/07/2006 12:00:00 AM | 3 | 3X3 | 6017299.77103 | 2098787.22136 | 37.7438402086508 | -122.38282015645201 | (37.7438402086508, -122.382820156452) | ||
| 22352 | 22352 | 3605 | Private 5 | Quercus ilex :: Holly Oak 78 | 100X Cargo Way | 41 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Port 9 | 6 | 3X3 | 6018137.75637 | 2098119.86028 | 37.7420540318827 | -122.37987620861601 | (37.7420540318827, -122.379876208616) | |||
| 23263 | 23263 | 3508 | DPW Maintained 3 | Quercus ilex :: Holly Oak 78 | 201X Cargo Way | 18 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 5 | 3X3 | 6017980.680269999 | 2098133.15007 | 37.7420818568975 | -122.380420257114 | (37.7420818568975, -122.380420257114) | |||
| 51545 | 51545 | 3580 | Permitted Site 1 | Quercus ilex :: Holly Oak 78 | 100X Cargo Way | 15 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Port 9 | 6 | 3X3 | 6018980.3390981 | 2097500.2540781004 | 37.740399159699294 | -122.376919818221 | (37.7403991596993, -122.376919818221) | |||
| 56191 | 56191 | 3589 | Permitted Site 1 | Quercus ilex :: Holly Oak 78 | 100X Cargo Way | 25 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Port 9 | 05/31/1996 12:00:00 AM | 3 | 3X3 | 6018406.34137 | 2097917.94858 | 37.741514435040294 | -122.37893349789302 | (37.7415144350403, -122.378933497893) |
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");